UBB.threads PHP Forum Software Community Forums Resources and Customizing Admin Zone How to purge database before restoring a backup?

I am not well versed in php and mysql and am finding Gizmo's tutorials invaluable. Thank you Gizmo!

I am in the process of moving to a new VPS and in doing so I have made a trial run at moving my database using Gizmo's command line instructions. So now I have an old version of my database sitting on the new server.

In Gizmo's tutorial on backing up, he mentions that "And to restore said backup, after you purge data out of the MySQL database:" - which I believe would mean that I now have to purge that old database version before I can install the current database.

How do I do that? Any suggestions? All help is appreciated!

Hmmm... I tried selecting all of the tables in phpmyadmin and clicked "empty". I guess that works...

I usually copy the list of tables to a textfile, and do a search replace to end up with a large list of DROP TABLE statements.

hehe, i simply create a new DB with no tables and then import.. the mysqldump has the create tables and the mysql import specifies which DB you are importing to..

bada bing *poof*

Yeah, I thought of that but I had a bad experience with that in the past. I am using Cpanel and using their mysql management tool - in the past when I deleted a BD and then tried to create a new on with the same name - the program would not let me. I would have to create a new DB with a different name

no probs then.. what you did is fine.. you essentially dropped all the tables..

so you are at the point where you can create the tables

Thank you

Use PHPMyAdmin and click "drop tables" on the table select screen; that's how I do it ...

Thanks Gizmo, I will do that.

Duh, how simple

Fun how you can look over things for years