PDA

View Full Version : Getting MYSQL data back

Rossback
12-30-04, 10:55 PM
Something happened to my data. Now I have the dump file but how do I put it back into phpMyAdmin?

thanks.
tbonekkt
12-30-04, 10:57 PM
Go to the SQL tab in http://phpmyadmin.powweb.com and use the textfile method.
Rossback
12-30-04, 10:58 PM
Thank I'll try it
Rossback
12-30-04, 10:59 PM
I get an error:


Error

SQL-query :

--
------------------------------------------------------- --
--
--
DROP TABLE IF EXISTS address_book

MySQL said:


#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 '---------------------------------------------------------
--
--
tbonekkt
12-30-04, 11:01 PM
Open the dump file in Notepad (not Wordpad) and edit out the part where it says DROP TABLE.
Rossback
12-30-04, 11:06 PM
Alright, Thanks alot man. By the way you guys are quick on here! Excellent! Thanks!
tbonekkt
12-30-04, 11:09 PM
Interesting...I'm going to step aside and let the php gurus take it from here. ;)
Rossback
12-30-04, 11:13 PM
Naw, I got it. I just didn't edit it all out the first time, When I went to osCommerce (what the database has on it) It all came up correctly and works great. Thanks again!
tbonekkt
12-30-04, 11:13 PM
Oh great!! Maybe I've graduated to high school php level. :D