Yeah Brole my site how to fix it?

[forest1]

Ok while trying to fix an other problem via myphpadmin I ended up breakng the site

Now I have a back up of the data base in the format of a SQL dump. How do I go back to the old one

I tried up loading the old sql file but it didnt work

 

Thanks

[Guest]

Keith,

 

 

 

If the SQL was created using the ADMIN>>Tools>>Database backup button, then you click restore from the same area to restore the old database. If you exported the database using phpmyadmin, then you can drop all of the current tables and then IMPORT the database dump using IMPORT in phpmyadmin.

 

 

 

 

Chris

[forest1]

Hi

I did the second one

 

 

 

I tried doing that but I keep getting error messages

 

SQL query:

 

--

-- Database: `name of DB`

--

CREATE DATABASE `name of DB` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;

 

MySQL said: Documentation

#1007 - Can't create database 'name of DB'; database exists

[Guest]

Keith,

 

 

You are not trying to create a NEW database, just import the SQL dump into your existing database. Also, check the SQL to ensure it is properly formatted.

 

 

 

 

Chris

[forest1]

Hi

I know I am not creating a new DB but thats the message I am getting

I go to db -> import and import it as txt file

 

I have also tried going to SQL and pasting in the code