Berlie Posted October 7, 2004 Posted October 7, 2004 I am trying to move the phpbb forum database from my old server to TCH and I am having trouble. I think them trouble is with the actual backup. I tried to use phpmyadmin to create a backup of the database on my old host. Doing a backup of the entire database gave me a file that was 0 kb in size. I was able to do a backup of each individual table Except for phpbb_posts, phpbb_posts_text, phpbb_phpbb_topics and phpbb_privmsgs_text. The backup file on those were also 0 kb. Those tables are the ones that are the largest. My old host had shell access so I decided to try that to get a good backup instead of using phpmyadim. I did a backup of each table separately and it seemed to be ok. However when I try to restore these to the database at TCH I am getting the following error message: Error SQL-query : -- ------------------------------------------------------- -- -- -- CREATE TABLE phpbb_privmsgs_text( privmsgs_text_id mediumint( 8 ) unsigned NOT NULL default '0', privmsgs_bbcode_uid varchar( 10 ) NOT NULL default '', privmsgs_text text, PRIMARY KEY ( privmsgs_text_id ) ) TYPE = MYISAM 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 '--------------------------------------------------------- -- Any ideas? I ran a Check Table on them and it came back ok. The forums are still live on the old forums and I am not having any trouble with it there. Could the tables be corrupted in some way that is causing this issue, if so am I screwed?? I notices the old host was running MySQL 4.0.16 and TCH is running MySQl 4.0.20.. would that cause any problems? Quote
jandafields Posted October 7, 2004 Posted October 7, 2004 Your SQL cannot have those dashes in it at the top. That is incorect syntax. Take out the dashes at the top and try again... Quote
Berlie Posted October 7, 2004 Author Posted October 7, 2004 Thanks! Opened them up and removed those lines that were put in the backup and it seems to be restoring ok now. Quote
TCH-Don Posted October 7, 2004 Posted October 7, 2004 If your old host has cpanel you can use backup > Download a SQL Database Backup and to restore here backup > Upload a SQL Database Backup Quote
waynemac Posted November 3, 2004 Posted November 3, 2004 Hi all, just wondering...probably something written in the users manual but I`ll ask...when I have a backup of my site or db ftp`d to me does that count towards my monthly bandwwidth allocation? If I do a save to TCH host backup my site gets to 30MB. I did a full site backup send request and it go to 40MB so I hit the eject button as I was unsure how far things would go. Any input appreciated, Wayne Rock Sign Quote
TCH-Bruce Posted November 3, 2004 Posted November 3, 2004 Hi all, just wondering...probably something written in the users manual but I`ll ask...when I have a backup of my site or db ftp`d to me does that count towards my monthly bandwwidth allocation? Any activity that generates bandwidth in your account counts against your total bandwidth. So to answer your question, yes it would count. As for the second part of your question I am not sure what you are asking. Quote
waynemac Posted November 3, 2004 Posted November 3, 2004 Bruce, thanx for your reply. The 2nd part of my posting was saying that I requested a backup that was automatically saved to my computer (saving to my computer rather than the TCH server). Usually when I do a backup to the TCH server (and get a mail confirmation) the file comes out at about 30MB. The file that was saving to my computer got to 40MB and I cancelled the backup. There must be a different compression method between a backup to the TCH server and a backup to the website owners computer. Just wondering why the difference in backup file size... Hope I have explained it better...still kinda dribbly though. Wayne Quote
TCH-Bruce Posted November 3, 2004 Posted November 3, 2004 Okay, I understand what you are asking now. Sorry, I don't know the answer to this one. Hopefully someone else may have the answer. Quote
TCH-Don Posted November 3, 2004 Posted November 3, 2004 If you leave the last backup on your space, it will be part of the next backup. I do not bother with the full backup, as I can't upload it myself So I just download the home backup which you can upload in the same place. The home backup has everything, incluuding your e-mail, except databases and e-mail filters and alias which you can also download and upload in cpanel > backup.. Quote
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.