|
|
| Register now to interact with over 11,000 members! Registered users have Posting Privileges, free access to Private Messaging, Email Notifications and more. |
|
|||||||
 |
|
|
Thread Tools | Search this Thread |
12-30-04, 10:55 PM
|
#1 |
|
Posts: n/a
|
Getting MYSQL data back
Something happened to my data. Now I have the dump file but how do I put it back into phpMyAdmin?
thanks. |
|
12-30-04, 10:57 PM
|
#2 |
|
Join Date: Dec 2002
Location: TX
Posts: 12,381
Reputation: 248
|
Go to the SQL tab in http://phpmyadmin.powweb.com and use the textfile method.
__________________
Thank you to all forum participants. |
|
|
12-30-04, 10:58 PM
|
#3 |
|
Posts: n/a
|
Thank I'll try it
|
|
12-30-04, 10:59 PM
|
#4 |
|
Posts: n/a
|
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 '--------------------------------------------------------- -- -- |
|
12-30-04, 11:01 PM
|
#5 |
|
Join Date: Dec 2002
Location: TX
Posts: 12,381
Reputation: 248
|
Open the dump file in Notepad (not Wordpad) and edit out the part where it says DROP TABLE.
__________________
Thank you to all forum participants. |
|
|
|
12-30-04, 11:06 PM
|
#6 |
|
Posts: n/a
|
Alright, Thanks alot man. By the way you guys are quick on here! Excellent! Thanks!
|
|
12-30-04, 11:09 PM
|
#7 |
|
Join Date: Dec 2002
Location: TX
Posts: 12,381
Reputation: 248
|
Interesting...I'm going to step aside and let the php gurus take it from here.
__________________
Thank you to all forum participants. |
|
|
|
12-30-04, 11:13 PM
|
#8 |
|
Posts: n/a
|
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!
|
|
12-30-04, 11:13 PM
|
#9 |
|
Join Date: Dec 2002
Location: TX
Posts: 12,381
Reputation: 248
|
Oh great!! Maybe I've graduated to high school php level.
__________________
Thank you to all forum participants. |
|
|
|
| Thread Tools | Search this Thread |
|
|
