Results 1 to 2 of 2

Thread: Mysql large file import

  1. #1
    Join Date
    Jan 2007
    Location
    Manila, Philippines
    Posts
    62
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Red face Mysql large file import

    I have recently back-up my production database which is 160mb sql files... My problem is that I would like to have local back-up copy on my pc. Since restriction and exception hits on my phpmyadmin tool. Is that possible to chunk down each sql file into pieces let say 20mb sql file size... Is that posible and can you post it what software or steps should i take...


    Thanks

  2. #2
    Join Date
    Jan 2008
    Posts
    4,167
    Thanks
    28
    Thanked 628 Times in 624 Posts
    Blog Entries
    1

    Default

    To download a copy of your sql, simple go in phpmyadmin, click on a database, find the tabs that look like this:


    And click "Export"

    You should see something like this:


    Select the file type on the left, and then click "Go."

    As for "chunking down" the sql file to 20mb, I dont know.
    Jeremy | jfein.net

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
  •