Thread: Backup & Restore

Hi Smoge,

Sorry for all the trouble but Smoge, can you or someone tell me how to make a full backup of my data & then how to restore the information to a new database. ?? I need this help urgently.

Keep well

Rusty

Hi,

Perhaps the most direct way is phpMyAdmin...

You can either "Export" the data, and download it...

Or use the operations pages, to make a copy on your server (without a download).

If you want to use the command line, there are some helpful posts in the Database forum.

I find that the phpMyAdmin export method usually works well - but you should try to do an import of the backed up data before you accept the backup as being good (and delete something)

Smoge

Hi & Thanks Smoge, i will try it... Cant say I'll be successful but its worth a try.

Thanks for all your help

Rusty

Here is the link I was talking about - in regards to doing a database backup from the command line.

Backing up your database from the command line

Smoge

I also use mysql administrator but phpmyadmin is best.

Would love to help drop me a line if you have any problems.