Results 1 to 6 of 6
  1. #1

    Exclamation Phpmyadmin wont dump file! HELP

    Hi, I went into a sql db and tryed to dump the data & structure or w/e and it acts like it is loading and just goes to a blank screen. When I try the same thing on my smaller db it does it fine, but since this one is 120mb is that why it is messing up? If so how do I fix it.


  2. #2
    It might be because it is so large, yes. You can have phpMyAdmin send it as a file instead, and then just save it locally to your machine.
    Hosting Matters, Inc.
    Superior service. Sensible price.

  3. #3
    Thats what I was trying to do...

  4. #4
    Join Date
    Jun 2002
    log into your ssh/telnet and dump database manually.

    phpmyadmin cant backup/restore large database .
    and "4MB" database is considered as "large" for data restore
    (however, for backup, it may support up to 10MB)

  5. #5
    Join Date
    Apr 2001
    Try using

    mysqldump --opt -uUSERNAME -p PASSWORD databasename > dumpfile.sql
    Shared Web Hosting - Reseller Hosting - Semi-Dedicated Servers - SolusVM/XEN VPS
    LiteSpeed Powered - R1Soft Continuous Data Protection - 24/7 Chat/Email/Helpdesk Support
    Cpanel/WHM - Softaculous - R1soft Backup - Litespeed - Cloudlinux -Site Builder- SSH support - Account Migration
    DowntownHost LLC - In Business since 2001- West/Center/East USA - Netherlands - Singapore

  6. #6
    Join Date
    Sep 2001
    Vienna, Austria
    i always use this for my large databases. works great.

    mysqldump -uUSERNAME -pPASSWORD dbname | gzip > dbname.sql.gz

    gunzip < dbname.sql.gz | mysql -uUSERNAME -pPASSWORD dbname

    of course in plesk it's all funky and a tad different, but, works fine for me.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts