Question On Dumping MySQL
Stupid question, I know, but the database on my PHP toplist is broken and I can’t put it together again. The error is crashing my site.
I deleted the offending table, but I can’t seem to replace it with the DB from my backup, whether I upload or cut-and-paste.
I have a backup from late October, but if I import the data, it gives me errors, telling me “Table already exists.” How I can override this?
At this point, all I want is to have my backup in place and get the site live again.
How do I do this with PHP myadmin?
Answer
First delete all the table in the MySQL. Then only you can upload back the backup files. Open the .sql files in your wordpad and delete the “create table line”.
RSS feed for comments on this post · TrackBack URI
Leave a reply