unrelenting Posted February 7, 2009 Share Posted February 7, 2009 I have a huge database (over 300 megs). I backed it up but I did it wrong because when I set up my new one on a different server bigdump won't add the data because the tables don't exist. I used SMF built in backup method and apparently it didn't write the table structure into it. So is there a way I can just dump the structure of this database in PHPMyAdmin and just install it on my new server and then import the massive backup? I hope this makes since? Quote Link to comment Share on other sites More sharing options...
corbin Posted February 7, 2009 Share Posted February 7, 2009 Uncheck the box next to "Data" on the export page. Quote Link to comment Share on other sites More sharing options...
unrelenting Posted February 7, 2009 Author Share Posted February 7, 2009 Uncheck the box next to "Data" on the export page. Wow. Doh! Thanks. Quote Link to comment Share on other sites More sharing options...
corbin Posted February 7, 2009 Share Posted February 7, 2009 No problem ;p. Quote Link to comment Share on other sites More sharing options...
unrelenting Posted February 7, 2009 Author Share Posted February 7, 2009 My massive database dump, for the second time, contains a duplicate line and errors out using bigdump.php or SSH. This is a 3 hours process to download a new one and upload it the the new database. I can't even edit the file manually because it is too large to open in a text editor. Is there a way to get this thing installed as is? Ideas? Quote Link to comment Share on other sites More sharing options...
wizardry Posted February 7, 2009 Share Posted February 7, 2009 what type of system are you using? windows? linux? hopefully linux! you can use the mysql dump this is the link to it and all variables. http://dev.mysql.com/doc/refman/5.1/en/mysqldump.html it's easier to use then phpmyadmin and you can add it to a cron job to do your back ups for you. i suggest createing a new bkup using mysqldump then load it into the database the link provided will have all the needed variables for this method. Quote Link to comment Share on other sites More sharing options...
corbin Posted February 7, 2009 Share Posted February 7, 2009 mysqldump is available on Windows too. Quote Link to comment Share on other sites More sharing options...
wizardry Posted February 7, 2009 Share Posted February 7, 2009 i know i didnt say it wasnt Quote Link to comment Share on other sites More sharing options...
corbin Posted February 7, 2009 Share Posted February 7, 2009 "what type of system are you using? windows? linux? hopefully linux! you can use the mysql dump" Why did you ask if he was using linux? Was it so he can use cron? There are of course cron alternatives on Windows, and, if you want to play the "When did I say it wasn't?" game... when did he say he wanted to run it more than once? Quote Link to comment Share on other sites More sharing options...
wizardry Posted February 7, 2009 Share Posted February 7, 2009 lol..... if you refer to unrelenting last posted unrelenting said that one of the backups was to memory consumming and still errored out. well second time as in plural. asumming using proper english would mean more then one. yes there are multiple ways of creating a backup and putting it on a schedule. but any who next subject. since you have time to question my responses to this post; can you question and possibly help me on this one that i posted topic: mysql insert loop thanks in advance Quote Link to comment Share on other sites More sharing options...
unrelenting Posted February 7, 2009 Author Share Posted February 7, 2009 Thanks for the advice but I finally got it to take using REPLACE INTO rather than the INSERT INTO. I had to send the file to my friend who has a much faster computer than mine and he was able to open it and make the edits. Quote Link to comment Share on other sites More sharing options...
corbin Posted February 8, 2009 Share Posted February 8, 2009 "if you refer to unrelenting last posted unrelenting said that one of the backups was to memory consumming and still errored out. well second time as in plural. asumming using proper english would mean more then one." Second time as in second time he tried it because the first time it didn't work. Not second time he had it scheduled. @unrelenting: Unless you have data already in the tables that would cause errors, INSERT should work fine x.x. Quote Link to comment Share on other sites More sharing options...
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.