[RESOLVED] Backup local MySQL database...

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?


- ØØ -

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...

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

I just export them into .sql files and upload them that way.
~~~~~~~~~~~~~~

Quote:

---

Originally Posted by visualAd

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.

---

Quote:

---

Originally Posted by NoteMe

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

---

How was he rude


????