MySQL is an Open Source database now owned by Oracle. The MySQL documentation is expansive and incredibly useful.

learn more… | top users | synonyms

3
votes
1answer
556 views

Shell script of mysqldump works fine when run manually, but does not run in the cron job?

I have a shell script to get a MySQL database dump. This script works fine when run manually #!/bin/sh fqn=/home/Mysqluser/daily_dumps/bookstore_`date +%Y%m%d_%H%M%S`.sql.gz mysqldump -u root -h ...
3
votes
1answer
544 views

How to completely remove MySQL files from my windows computer

I have recently installed apache, php, and mysql. Apache and php are configured properly, but when I tried to configure mysql it shows that there is already a security file for mysql that is setup and ...
3
votes
2answers
118 views

MySQL optimisation in Linux

I am performing massive insertion operation towards a MySQL database (100+ million records). Afterwards, I select records out of the two tables using for the most part their primary key. I seek to ...
2
votes
4answers
189 views

What is the best way to convert a MySQL database to an access database?

I need to convert databases both directions and I also need to grab subsets of data on occasion. Is there an easy way to do this?
2
votes
3answers
135 views

Linux Web Server

I'm looking to set-up my own local web server using Linux, to allow me to run and develop PHP applications using Apache and MYSQL. Can anyone recommend the best distribution of Linux server to use. ...
2
votes
4answers
6k views

Can't create a MySQL dump on Windows, fails before password prompt

I'm trying to create a dump of a locally installed MySQL database on my laptop. I am aware of the command: %>mysqldump -u root -p --opt [database name] but I am not able to execute it. I might ...
2
votes
2answers
139 views

Why would a MySQL function be getting randomly dropped?

I have the following function that is used in several databases on my server. CREATE FUNCTION `fn_strings_intersect`(arg_str1 VARCHAR(255), arg_str2 VARCHAR(255)) RETURNS varchar(255) CHARSET latin1 ...
2
votes
1answer
104 views

SQL import size

I'm in the process of importing a couple of SQL dumps into my own mySQL server. The size of these dumps, from Wikipedia, are 2.3 GB and 22 GB. Is the size of an SQL dump file approximately the same ...
2
votes
3answers
2k views

Free Wiki software that can easily convert to confluence

Simply: What is some good free Wiki software that can be quickly/easily ported over to confluence? More specifically: We need something free that we can use to build up a repository of documentation, ...
2
votes
3answers
1k views

What's difference between this: sudo find /usr/local/mysql/data -type f -exec rm {} ';'

What's difference between this: sudo find /usr/local/mysql/data -type f -exec rm {} ';' and this: sudo rm -rf /usr/local/mysql/data
2
votes
5answers
455 views

Safe remote mysql connection

As you know, keeping the mysql port 3306 opened is unsafe - but I would like to use a good mysql administrative program instead of phpmyadmin, which requires 3306 port to be opened. Of course I can ...
2
votes
2answers
1k views

Public MySQL servers for use in sample code

Similar to how the IETF's example.com domain's web and email services can be safely used in code samples, is there a public MySQL server I can safely(*) use in some sample code? ("Safe" in that it ...
2
votes
1answer
844 views

Different output when redirecting

$ mysql -e 'select a,b from tablefoo' databasename yields +---+---+ | a | b | +---+---+ | 1 | 0 | | 2 | 1 | +---+---+ whereas $ mysql -e 'select a,b from tablefoo' databasename > file ...
2
votes
1answer
2k views

How do I give a single user permissions over a schema in MySql Workbench?

I have a MySql server installed on a server along with MySql Workbench. About a year ago, I managed to do this and I felt like slapping myself as it was something so simple, but, I just can't ...
2
votes
2answers
7k views

Where is MYSQL installed on Mac?

I've always used MAMP or XAMPP to install MYSQL so it's been fairly straightforward. The only most I've had to do is create a symbolic link. I'm now starting to learn Django and I would like to ...
2
votes
3answers
4k views

How to copy MySQL database from one server to another?

I just finished making a website in Joomla! 1.6. Web sites in Joomla! consist of two basic parts. There are files which are used by HTTP server and there is the database. I have FTP access to the ...
2
votes
4answers
4k views

How can I install mySQL on CentOS without being root/su?

I want to install mySQL on CentOS. I do not have a root account on that machine. How can I install mySQL on CentOS as a user, ie. without being root?
2
votes
2answers
235 views

Weird behaviour with mysql port forwarding

I have set up MySQL port forwarding in my machine as: ssh -f -N -L :9906:localhost:3306 <ssh login> Now, if I try to connect to MySQL from my localhost as: mysql -u<user> ...
2
votes
1answer
2k views

What's the difference between .db and .sqlite files?

I had a look into a program's folder in Program Files of the Windows directory and I found that it has a lot of files with .db extension. I opened one with notepad and I saw that the first string in ...
2
votes
1answer
234 views

awk: equivalent of mysql's “\G” to print tabulated data in multiple lines

Is there an equivalent to mysql's "\G" at the end of the query but awk (or similar) that will to print tabulated data from a text file in multiple lines with the header next to it? Something that will ...
2
votes
2answers
2k views

Ubuntu, user can't write to a directory and I don't see why not

I've got a directory, /var/www/someProject/backup/mysql, and I want the user mysql to write to it. Each time I try to write to it with the mysql user, I get a "can't read/write" error. Yet the ...
2
votes
1answer
82 views

Terminal automatically moving me out of a directory?

I'm noticing a strange issue where I appear to be forcefully cd'ed out of my MySQL data directory every time I cd to it. I'm using Terminal.app on OS X 10.6.1. joebmaclap:mysql joeb$ cd ...
2
votes
1answer
77 views

How can I enforce atomic inserts?

I'm working on an application backed by a MySQL instance, and I've encountered strange behavior involving what seems to be "phantom" inserts. Given a table with an auto-incrementing integer key, I ...
2
votes
1answer
85 views

How to abandon current command in MySQL CLI?

In the MySQL/MariaDb command line client, if I have the cursor in the middle of a long query and I want to abandon that command I have to reposition cursor at the end of the line check whether the ...
2
votes
1answer
2k views

Mysql 5.6 server via MacPorts won't start

I've been happily using MacPorts' mysql5 and mysql5-server. Now it's time to upgrade. I followed standard procedure, but the server won't start. sudo port unload mysql5 sudo port install mysql56 ...
2
votes
2answers
2k views

$PATH issues with OSX Lion

I'm having some issues with running mysql from terminal: macmini:~ michael$ which mysql /Applications/XAMPP/xamppfiles/bin/mysql macmini:~ michael$ mysql -bash: /usr/local/mysql/bin/mysql: No such ...
2
votes
3answers
5k views

MySQL Workbench, start with auto commit off

I'm running MySQL Workbench 5.2, and whenever I make a connection to a database auto commit is toggled on. Is there any way to have the default behavior be changes so that auto commit is toggled off, ...
2
votes
4answers
2k views

I want find a good mysql Manager use on Ubuntu

On Windows, i use SQLyog. And I am new to Ubuntu. Is there any mysql manager programs as good as SQLyog?
2
votes
2answers
4k views

Why isn't my port forwarding with mysql working on my server?

I have a mysql server running on some server in our network. Now, only connections from localhost are accepted by the server and I can't connect to it remotely. Now, I want to set up a port ...
2
votes
1answer
2k views

Export MySQL database structure

I have a MySQL database. I would like to export the tables/structure to a script. I don't need the data, just a script to create all tables I have. I have access to PhpMyAdmin.
2
votes
1answer
770 views

How to manually install Apache, PHP and MySQL on Windows?

How do I install Apache with PHP support and the MySQL server on Windows without using any ready-to-use packages like WAMPServer or XAMPP ?
2
votes
4answers
503 views

MySQL - “Root Element is Missing”

Something has happened to the MySQL server installation on my computer. Normally, the MySQL notifier program, which is supposed to start automatically and run in the system tray has stopped starting ...
2
votes
1answer
90 views

How can I reimage my virtual server to not have size caps to individual directories?

As a prenote, I am extremely new to networking in general, and my knowledge is very minimal, even for things you guys would consider basic. I will try my best to keep up with any advice you have to ...
2
votes
1answer
819 views

issue on starting of mysql

I have installed "mysql-5.6.14-linux-glibc2.5-x86_64.tar.gz" in user specified directory. I tried to start the lam, but it is saying "Starting MySQL..The server quit without updating PID file ...
2
votes
1answer
2k views

Error installing mysql 5.5 FATAL ERROR: Could not find my_print_defaults

I installed Mysql 5.5 using Homebrew, specifically Homebrew versions - https://github.com/Homebrew/homebrew-versions. After the installation, I attempted to run the commands it suggests: Set up ...
2
votes
2answers
306 views

MySQL query fails instantly

I recently loaded a large (~5GB) database from an SQLdump into a local MySQL server database. Loaded fine after a couple of tries, and initially I could query without a problem, although queries took ...
2
votes
2answers
797 views

Rollback transaction in SQLyog

I use SQLyog as a client against MYSQL. I would like to execute an SQL script an optionally commit or rollback (as with the client SQLDeveloper). How can I do that with SQLyog? I've searched the web ...
2
votes
2answers
5k views

can't login in phpmyadmin and mysql after fresh installation of lamp server and phpmyadmin on ubuntu 12.04 LTS

I am trying to search a solution for this problem, but didn't find a solution. I am getting an error while login in phpmyadmin #1045 Cannot log in to the MySQL server Connection for controluser as ...
2
votes
1answer
2k views

Grant MySQL user ability to create databases, and only allow them to access those databases

Is it possible to grant a MySQL user the privileges to CREATE new databases, such that they have full access to the databases they create (including the ability to DROP those databases). But other ...
2
votes
2answers
107 views

How to show progress during the loading of a large sql dump?

I'm occasionally running gzcat dump.sql.gz | mysql5 -uroot -p dbname which can take hours to complete. Is there a simple, elegant way to show some progress percentage?
2
votes
1answer
317 views

MySQL Workbench Snap To Grid

I'm using MySQL Workbench 5.2.36 in OS X and was wondering where in the options is the Snap To Grid function when editing a model? I can find Show Grid, but that's all... it's sort of pointless ...
2
votes
1answer
717 views

How do I upgrade MySQL 5.0 to MySQL 5.1?

I need to upgrade my MySQL installation to version 5.1 from 5.0.37, and I have studied the documentation here and performed all the necessary preliminary steps but (call me stupid) I can't find ...
2
votes
2answers
2k views

Can I use MySQL Workbench to create data?

The MySQL Workbench seems to be a nice tool for create database schemata. When I export a model, there is a checkbox for "create insert statements". Thus, it should have an option to fill one's ...
2
votes
2answers
4k views

How to tune MySQL for restoration from MySQL dump?

My little 5GB database which takes 5 minutes to dump via mysqldump, takes 9 hours to restore. Luckily I found this out during a test-run, not an actual emergency situation. What are the best ...
2
votes
1answer
4k views

launchctl: Dubious ownership on file (skipping) (Mac OS X)

I installed mysql recently and added its start command in my .bash file. But when I tried running the command, that's when I encountered this error: launchctl: Dubious ownership on file ...
2
votes
2answers
2k views

MySQL root user missing, fresh installation

I have a fresh installation of MySQL (5.0.75-0ubuntu10.5) which I installed using apt-get. During the setup I was prompted for my MySQL root password which I set. Ever since, I have tried logging in ...
2
votes
4answers
182 views

MysqlDump Long Load Times

I am using mysqldump database > output.sql to dump all the data in a database. The size of the output file is around 3.3 GB. I am importing it using mysql < output.sql however it has been ...
2
votes
2answers
2k views

When setting up MySQL on a VirtualBox VM, can I connect to it from the host computer?

I have VirtualBox running Ubuntu on my Windows 7 computer. Is it possible for me to connect to the MySQL server running on the VM from my Windows 7 host?
2
votes
2answers
3k views

Cannot Start MySQL Server on Fresh MAMP Install

I'm using Mac OS X 10.6.2 on my Macbook Pro. I can get the apache server to start, but not the mysql server, on both the default apache and default MAMP ports. When I try to go to my start page, I ...
2
votes
1answer
796 views

Mac OS X 10.6.2 Install DBD::mysql

I've got a Mac Mini Server with Snow Leopard 10.6.2 64bit. I'm trying to install the Perl module DBD::mysql but cannot get it to work. Is probably worth mentioning that this is the first time I'm ...