sandsmuseum
05-21-2004, 03:05 PM
It appears there are two ways and perhaps more to back up a MySQL database.
Use phpMyAdmin and Export a copy. Then, delete the database to get rid of the table, create a new empty database, and then use phpMyAdmin to run the SQL script you saved. This appears to have size limitations on the upload.
Use the Backup panel in the cPanel X screen. While this is supposed to work, I was unable to get it to do so. I backed up MySQL and saved the file on my client side. I removed a record from the database on the server side and logout. I restored the database and the record did not reappear as I expected.
I am working on a Mac, have not learned if I can access the database with any other method than phpMyAdmin, and will be happily generating PHP code eventually... Any help will be greatly appreciated...
Michael
Use phpMyAdmin and Export a copy. Then, delete the database to get rid of the table, create a new empty database, and then use phpMyAdmin to run the SQL script you saved. This appears to have size limitations on the upload.
Use the Backup panel in the cPanel X screen. While this is supposed to work, I was unable to get it to do so. I backed up MySQL and saved the file on my client side. I removed a record from the database on the server side and logout. I restored the database and the record did not reappear as I expected.
I am working on a Mac, have not learned if I can access the database with any other method than phpMyAdmin, and will be happily generating PHP code eventually... Any help will be greatly appreciated...
Michael