Go Back   TechArena Community > Software > Software Development
Become a Member!
Forgot your username/password?
Tags Active Topics RSS Search Mark Forums Read

Reply
 
Thread Tools Search this Thread
  #1  
Old 08-07-2009
Member
 
Join Date: Apr 2008
Posts: 38
How to split large mysql database

Hey guys, i have a sql database and i need a script to backup my database and compress it and send the compressed file to my email account.
however some email account like gmail does not support emails larger than 20MB. so , it should be split and each part sent in separate email. Any idea how can i do this?
Reply With Quote
  #2  
Old 08-07-2009
Member
 
Join Date: Mar 2008
Posts: 198
Re: How to split large mysql database

To split the sql data base, you don't need any special software for that, just you need to open sql database file in the notepad file and cut and paste chucks of sqls to other notepad files. Save them and thn Import. Just you have to keep in mind that while cutting and paste chunks each begin and end with complete sql inserts. You can find the end by looking for the beginning of another insert table command. And the most important thing you should do is Don't export the data in the phpbb_search_wordlist table. This alone would account for half of your total database size. Export only the table structure for this table.
Reply With Quote
  #3  
Old 08-07-2009
Member
 
Join Date: Jan 2008
Posts: 1,515
Re: How to split large mysql database

Import Large MySQL data dump with BigDump
  1. Enter database/login info into BigDump PHP script
  2. Upload script file and MySQL datafile to writable, web-accessible directory on your website.
  3. Run the script by navigating to your website URL containing the BigDump script.

Result: Script loads data by breaking the large file into smaller chunks and loading each chunk separately into the database. Very smooth.
Reply With Quote
  #4  
Old 08-07-2009
Member
 
Join Date: Feb 2008
Posts: 1,848
Re: How to split large mysql database

Use SQL Dump File Splitter , This is very useful and a great tool. It helped me also a while back. if your phpMyAdmin has a SQL filesize limit and you have a huge backup to restore, then this is the ideal database tool for you. You can also choose to skip Comment-Lines and also set the filesize of each partition. And also see this thread : How to email a very large file?
Reply With Quote
Reply

  TechArena Community > Software > Software Development
Tags: , , ,



Thread Tools Search this Thread
Search this Thread:

Advanced Search


Similar Threads for: "How to split large mysql database"
Thread Thread Starter Forum Replies Last Post
How to split large files in Mac OS X strongArm Operating Systems 5 31-07-2011 10:04 AM
Steps to split large files into several parts with GSplit Kaufman Windows Software 5 18-02-2010 05:48 AM
How to split large flv files ? FELIPA Windows Software 3 19-06-2009 04:16 PM
How to split a large partition in Vista without loosing data? Bracken Operating Systems 3 08-05-2009 02:11 PM
How To Split Large Files into Smaller Zip files with Akhir Split Zip Spykar Tips & Tweaks 1 25-04-2009 05:17 PM


All times are GMT +5.5. The time now is 01:09 PM.