Thread: Database help please!

Help!

I think I've totally screwed my database trying to manipulate the profile fields. I made a backup copy before I changed anything so my question is how do I restore it from phpMyadmin?

Thanks.

phpMyAdmin only works with small(er) files, so if your database is really big (more than a couple of MB), you should use the mySQL command line.

There are many ways - and some issues you need to be careful of... but here is a start.

Login to phpMyAdmin.

Do another backup (just in case) to a different file name.

Server: localhost Database: databasename

This will display a list of all your tables

At the bottom, choose Check All

Then With Selected: choose Drop

This will empty your database, but keep it "open" so you can import your SQL file.

You will need to confirm you want to do this.

Then, choose SQL

And then use the browse button to choose the location of the text file (SQL) on your system.

Hit Go

Wait while it uploads.

With some luck, you will have restored your backup.

Smoge

Well, I tried your suggestion Smoge but I'm getting syntax errors like this:

MySQL said: Documentation
#1064 - You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'desc varchar(255) NOT NULL,
Type enum('digit','text','checkbo

I'm on a Linux Server running MySql version 4.0.25-standard.

Here's the funny thing...this is a DB copy straight from my server that worked 4 days ago when I created it as a backup.

Smoge or anyone else have any ideas. BTW, this is a CLEAN DB version.

Help!