How to restore to mySQL? I have phpmyadmin. 1

[rblanc]

How can I restore to mySQL using phpmyadmin?

I created a database and now I want to restore from another db to a newly created database. I have it save on my local drive.


rick

 

[Bastien]

what table type? for myisam, you can go to the data folder in the mysql folder and copy the files from the old db to the new db's folder

Bastien

Any one have a techie job in Toronto, I need to work...being laid off sucks!

 

[rblanc]

I am trying to get back my data from a phpbb2 v2/0.6 to a newely intalled pnpBB2 v 2.0.8

I used the restore from within phpBB2. I received the message below.

I think my earlier install of phpbb 2.0.6 was using mySQL v 3.x now I installed phpBB 2.0.8 with the mySql 4.x option.

Could this be the problem? The backup file has a gz extension. This error message from phpBB is below. This is way out of my field.


Error importing backup file

DEBUG MODE

SQL Error : 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 '--------------------------------------------------------- -- Se

-- MySQL dump 8.23 -- -- Host: mysql02.powweb.com Database: sofacts --------------------------------------------------------- -- Server version 4.0.15 -- -- Table structure for table `AT_content` -- DROP TABLE IF EXISTS AT_content