MySQL Database backup?

[Anon]

Hi,
I need to change out the disk on my webserver, and I would like to transfer the databases on the disk to the new disk.
Anyone has any good ideas how to do this?

Thanks
Carsten

[Anon]

man mysqldump

[Anon]

The safest way to back up a MySQL database is to use mysqldump which dumps the database in a text-file containing SQL statements:
mysqldump -c -u root -p DATABASE >DATABASE-backup.sql
(on one line)

Then, on the fresh MySQL, you restore the database by
1. Creating the database in the MySQL shell:
create database DATABASE
2. Jump out of the MySQL shell, and:
3. Run:
mysql -u root -p DATABASE <DATABASE-backup.sql
(on one line)

[Anon]

Umm.. But what if I have 30, 40 or even 100 databases?

[Anon]

this works great when i dump from and to a linux mysql server but when i try to dump it in a windows server somehow it doesnt work.. any ideas ?

[Anon]

It's just work for the data, but not image.
Is there any way to restore the image files?
Thanks for your help in advance.

[Anon]

Stop mysqld, backup all files in mysql data directory, then restore'em in a new location (at a new server, for example). This works fine.

[Anon]

I just finished writing an implementation that backs up images.

INSERTING doesnt seem to work and LOAD DATA has the problem of what your field delimeter is. The way I did it was to create images using PHP ImageCreateFromString and ImageJPEG (or GIF etc) then write an "UPDATE tablename set imagefield=LOAD_FILE("the path of your image") where etc...;" in your script