Results 1 to 4 of 4

Thread: How to split large mysql database

  1. #1
    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?

  2. #2
    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.

  3. #3
    Join Date
    Jan 2008
    Posts
    1,521

    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.

  4. #4
    Join Date
    Feb 2008
    Posts
    1,852

    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?

Similar Threads

  1. How to split large files in Mac OS X
    By strongArm in forum Operating Systems
    Replies: 5
    Last Post: 31-07-2011, 10:04 AM
  2. Steps to split large files into several parts with GSplit
    By Kaufman in forum Windows Software
    Replies: 5
    Last Post: 18-02-2010, 05:48 AM
  3. How to split large flv files ?
    By FELIPA in forum Windows Software
    Replies: 3
    Last Post: 19-06-2009, 04:16 PM
  4. Replies: 3
    Last Post: 08-05-2009, 02:11 PM
  5. Replies: 1
    Last Post: 25-04-2009, 05:17 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Page generated in 1,711,727,043.52295 seconds with 16 queries