jrwrestling Posted December 17, 2003 Share Posted December 17, 2003 My backup file is 19MB in .sql format, every time I attempt to restore, it crashes. Any pointers? Link to comment Share on other sites More sharing options...
Guest Posted December 17, 2003 Share Posted December 17, 2003 You'll need to choose the option "Download ONLY".... When you are ready to restore your db, you'll have to break your backup file down into mulitple files and run the restore process via PHPMyAdmin or whichever program you use to maintain/edit your db. With your file being so large in size, you'll have to make it into multiple files. Trent :blink: Link to comment Share on other sites More sharing options...
1quicksi Posted December 17, 2003 Share Posted December 17, 2003 This is only if you are using a browser. If you have command line access you can restore the database without having to do this. knowledge base | Contributions | Search Link to comment Share on other sites More sharing options...
jrwrestling Posted December 17, 2003 Author Share Posted December 17, 2003 How do I go about splitting the files? Link to comment Share on other sites More sharing options...
Guest Posted December 17, 2003 Share Posted December 17, 2003 cut it in half . .. actually, you can open in a text editor, and then as you go thru the file, you will see where tables are dropped, created, and then info inserted into the tables. choose about 1000 lines at a time, making sure you end after items have been inserted into the table Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.