Using Phpmyadmin Properly To Backup Database

[djk]

using phpMyAdmin to backup my database I select the database I want to back up.

I checked Structure,and under Structure

Add DROP TABLE,

Add IF NOT EXISTS,

Add AUTO_INCREMENT value,

ENCLOSE table and field names with backquotes

 

I checked Data, and under Data,

Complete Inserts,

Use hexadecimal for binary fields,

 

Export type was INSERT

 

I checked Save as File

Under Compression I selected none.

 

Hit Go and downloaded the file.

 

At my old host I had shell access and used MySQL commands so please tell me if this formula I used is proper as it is a new experience to use phpMYAdmin.

 

Another question I have is on the home page under Create new databases it has in red "X No Priviledges", but below that if I click on Databases it seems I can create a new one as the option is there. Am I missing something here? Thanks for any help. By the way I did searches, but I'm mostly interested in if this exact series of steps will create a proper database or if I need to add or drop certain options. Again, thanks for any pointers.

[TCH-Bruce]

Sorry, I have no knowledge of using phpAdmin to do a backup of the databases. I use the backup function of cPanel to create my backups.

 

I also use a script called dbsender to email daily backups to myself.

 

I'm sure someone familiar with phpAdmin will be along to offer suggestions.

[djk]

Sorry, I have no knowledge of using phpAdmin to do a backup of the databases.  I use the backup function of cPanel to create my backups.

 

I also use a script called dbsender to email daily backups to myself.

 

I'm sure someone familiar with phpAdmin will be along to offer suggestions.

<{POST_SNAPBACK}>

 

thanks for that info.

[TCH-Don]

I find it easier to use cpanel > backup

and just click on the database I want to download

and I can upload the same way.

 

I believe MySql is the way to create database rather than phpmyadmin.

[jhollin1138]

I use a couple of cron jobs and back-up every evening automatically.

 

For the actual back-up, I use the method described here. I also have cron job set up to save a copy of last nights back-up before starting a new back-up This way, if my new back-up fails, or me MySQL becomes corrupt prior to the next scheduled back-up I should only lose 24 hours.

 

I do need find an automatic way to keep a copy off the server in case of a disk or server failure. I am going to look into "dbsender" for this, thanks again Bruce.

[OmicronLab]

After reading post of Bruce Richards, I installed dbsender. Dbsender sent me the 1st backup today. Thanks Bruce!

 

By the way, I'm not a mysql guru. How do I restore this backup if needed. As far as I know, backups created by dbsender cannot be restored by cpanel database restore.

 

Plz help.

[TCH-Thomas]

It should be restorable, you might need to rename it though to the orignal name. If the backup is called for instance "cpanelname_your chosen database name-030107-0200am_sql.tar.gz" rename it to "your chosen database name.gz" and follow the instructions:

 

1. Log in to cpanels backup section

 

2. Go to "Restore a MySQL Database"

 

3. Click browse to find your database on your local computer

 

4. Click upload.

[OmicronLab]

It should be restorable

 

I cannot play with my database, my whole site (Joomla)+forum(Ipb) may crash with all my efforts of last four years. Anyone there who is sure? Who can say it "must be", instead of "should be"?

 

I noticed that the Cpanel Backup Database Size and Dbsender Backup database sizes are different for same database. Why this happens?

Edited March 1, 2007 by OmicronLab

[austin]

I cannot play with my database, my whole site (Joomla)+forum(Ipb) may crash with all my efforts of last four years. Anyone there who is sure? Who can say it "must be", instead of "should be"?

Do you have extra domains that you could create a test setup? You could also use something like yoursite.com/test/ and replicate your current setup there and use it for testing. You can password protect it through cpanel to keep anybody from accidentally coming across it.

 

It's always good to test out your backup/restore procedures in case something happens.

[OmicronLab]

Thanks to all. Bruce gave me the simpliest solution by PM reply. "Let people of help desk to restore it."