 |
Trouble Restoring Forum Database (table Structure+data) |
 |
Member Login
Welcome
Welcome to the Zymic webmaster forums. Our forums are here to provide people the free ability to discuss a range of websites related topics such as design, development coding and marketing.
In order to post you will need to register for a zymic account or if you already have one simply login by using the form on the left.
 |
Zymic Webmaster Forums Zymic Free Web HostingDatabases & MySQL |
 |
 May 3 2011, 04:51 PM
Post
#1
|
|
|
Newbie  Group: Members Posts: 5 Joined: 3-May 11 Member No.: 188,898  |
I basically did the same thing this guy did, and have the same question.
I backed up the database via SMF's Forum Maintenance - 'Save the table structure' and 'Save the table data. (the important stuff)' both checked. I'm attempting to restore the entire forum on Zymic hosting. I have a fresh forum set up, atm. The link I mentioned, suggests "restore the backup database to an empty table and then, install an 'upgrade' package of SMF on it." If that's the best way to go, how do I "restore the backup database to an empty table"? or is there a better option? *Edit* Using Zymic Database Uploader 1.1, I attempted to import the backup sql, but I got the error: "Error at the line 36677: (329, 'VanDaL', 1304296112, 0, 0, '', 1304298580, 'VanDaL', 0, 0, '', '', '', '942f50632fa6f779df228c4ef80aba611c6309d0', 'vandalist@o2.pl', '', 1, '1988-10-09', '', '', '', '', '', '', '', 0, 1, '', '', 0, '', 1, 0, 0, '', 1, 1, 0, 2, '83.26.82.174', '83.26.82.174', '', '', 0, 1, '', 17765, '', '', 4, 352, '4b7f');" "MySQL: Illegal double '79935e4956' value found during parsing Stopped on error" |
 |
 
|
 |
Replies
|
May 4 2011, 05:37 PM
Post
#2
|
|
 THE SILENT FORUM NINJA Group: Administrators Posts: 3,709 Joined: 23-January 10 From: on your screen Member No.: 127,507 |
well you should install smf first then delete the tables inside the db and NOT the db itself and then import it
|
|
|
|
Posts in this topic
Doan Trouble Restoring Forum Database (table Structure+data) May 3 2011, 04:51 PM
ssfdre38 its saying on the .sql file there was an error on ... May 3 2011, 05:40 PM
Doan its saying on the .sql file there was an error on ... May 4 2011, 02:11 PM Doan well you should install smf first then delete the ... May 5 2011, 04:13 AM ssfdre38 db = database May 5 2011, 04:30 AM Doan db = database
I know what the letters 'db... May 5 2011, 04:41 AM ssfdre38 as i said once its install drop all the tables in ... May 5 2011, 05:10 AM Doan New problem: I ran everything from the backup.sql... May 5 2011, 06:09 AM  |
|
1 User(s) are reading this topic (1 Guests and 0 Anonymous Users) |
|
| 0 Members: | ||
|
Forum Jump |
|
| Lo-Fi Version | Time is now: 24th May 2013 - 07:47 AM |