phpMyAdmin

[Anon]

How can I make a copy of my database to my computer (c:) using phpMyAdmin?

Tanks!

[[deleted]]

You can dump the table and structure, but don't do it with phpmyadmin. phpmyadmin is very bad at dumping data.

Instead, use the mysqldump program that comes with your mysql installation.

[Anon]

Are you just trying to back up your database? If so, just do what Vincent said before me - run the mysqldump program that came with your MySQL distribution. This program basically dumps all the SQL commands that are necessary to rebuild your entire database. The easiest way to "save" your database to your C:\ drive would be to type the following:

mysqldump -u "username" -p"password" dbname > C:\dbbackup.bak (or whatever you want to name it)

where "dbname" is the database you want to back up. This redirects all of the statements into the file dbbackup.bak. To restore a backed-up version of a MySQL database, you can type the following:

mysqladmin -u "username" -p"password" create dbname
mysql -u "username" -p"password" < C:\dbbackup.bak

[gettingold]

its interesting to hear you guys saying not to use phpmyadmin to dump data.

Ive used it on a number of occasions and its worked fine.

whilst im not disputing that there is a problem with phpmyadmin id be interested to know more.

any suggested further reading on this issue?

tia

[[deleted]]

phpmyadmin makes mistakes while dumping the data, somehow corrupting it sometimes,
and it has a serious problem with loading the dump back into mysql. hardly surprising because of all the addslashes() stripslashes() htmlspecialchars() etc that has to be done.

When you use mysqldump everything is much cleaner and thus more reliable.