phpmyadmin database export

Discussion in 'Linux VPS/Dedicated - cPanel' started by doulos, Sep 3, 2013.

  1. doulos

    doulos Member

  2. Dave G

    Dave G Member

    Not sure what your trying to do with the DB, but a cPanel backup may work your DB will be in the backup.
  3. Dan

    Dan Moderator

    Hi duolos,

    I don't know that there's much you can do about that. If it's a phpMyAdmin problem you should be able to export it from the command line though. Otherwise I see it's being worked on by phpMyAdmin and with something like that I am sure cPanel will implement the fix as soon as they can.
  4. doulos

    doulos Member

    Sorry about the IP, wasn't thinking I guess.
  5. NamiFlop

    NamiFlop New Member

    If the database is large enough that phpmyadmin cant support it login to ssh and do the following command

    To export use this command:
    mysqldump -u USER -p PASSWORD DATABASE > filename.sql
    To import database from dump file (in this case called filename.sql) use:
    mysql -u username -p password database_name < filename.sql
  6. doulos

    doulos Member

    Yes, thanks. I am able to backup the db outside of phpmyadmin. However, I like to be able to export only a few tables at a time and was able to do this easily with previous versions of phpmyadmin.
  7. KH-Dmitry

    KH-Dmitry Administrator Staff Member

    mysqldump -ae -u username -p dbname table1 table2 table3 > output.sql
    is going to dump only the specified table1, table2 and table3 tables.
  8. NamiFlop

    NamiFlop New Member

    i forgot about that one :D
  9. doulos

    doulos Member

    Thanks. Any way to limit the maximum length of a query using the above method. Several of my tables contain large amounts of data.
  10. zombie

    zombie Member

    It's a known bug in phpmyadmin. I've been anxiously awaiting it to be fixed but it hasn't to-date.
    Make sure your cpanel is set to auto-update so you receive the earliest update.
  11. Dan

    Dan Moderator

    The bug report in the original post says it's been fixed now. Hopefully soon! :)
  12. Dan

    Dan Moderator

    In the change log for
    • Fixed case 77013: Apply phpMyAdmin patch for large table export problem.

Share This Page