[RESOLVED] Backup local MySQL database... [Archive]

Click to See Complete Forum and Search --> : [RESOLVED] Backup local MySQL database...

NoteMe

Dec 19th, 2005, 07:36 AM

Is there any easy way to backup a local MySQL database, so I can transport them to an other PC and upload the tables with the info on that PC too?

- ØØ -

visualAd

Dec 19th, 2005, 03:05 PM

The database is held in a directory and the tables are held in individual files in the data directory for mysql. Therefore, if you make a copy of the database directory you want to back up,, this should be sufficient.

Remember however, when restoring them, you need to ensure you restore the appropriate permissions on the directory and its files.

NoteMe

Dec 19th, 2005, 03:35 PM

Thanks a bunch...but next time don't bee so rude...

McCain

Dec 19th, 2005, 04:33 PM

Or you could export them to textfiles using phpMyAdmin and import them using the same

PlaGuE

Dec 19th, 2005, 06:46 PM

I just export them into .sql files and upload them that way.
~~~~~~~~~~~~~~
The database is held in a directory and the tables are held in individual files in the data directory for mysql. Therefore, if you make a copy of the database directory you want to back up,, this should be sufficient.

Remember however, when restoring them, you need to ensure you restore the appropriate permissions on the directory and its files.

Thanks a bunch...but next time don't bee so rude...

How was he rude

????