Help on MySql Dump on Linux Fedora 2

  • I am having a problem dumping my sql database from previous server to the new one. I tried importing it through phpmyadmin but they have a limit of 2 mb where my database is 100 mb.

    New Server Info :
    Fedora 2
    MySql: 3.23.58
    phpmyadmin: 2.8.0.2

    more info on the server of the site
    • Fedora Core 2.0
    • Kernel 2.6.10-1.771_FC2
    • Apache 2.0.51-2.9
    • PHP 4.3.10-2.4
    • MySQL 3.23.58-16
    • BIND 9.2.3-13
    • SendMail 8.12.11-4.6
    • Perl 3:5.8.3-18
    • OpenSSH 3.6.1p2-34
    • Access by SSH/Telnet
    more info

    • Intel Pentium 3 667mhz (or better)
    • 256Mb RAM
    • 20GB Hard Disk Space
    • 1 Dedicated IP Address
    • 1000Gb Transfer

    Old Server Info:
    Server Type: winnt
    webserver: cgi-fcgi
    MySql Version:4.024-nt-max
    phpmyadmin: 2.5.6


  • You are having a problem dumping? Or restoring?

    Where are you hitting the 2mb limit?

    Dumping the database , the 2 mb limit is in phpmyadmin


  • this is what commend i am trying in terminal
    mysql -u user -p pass database_db then i check database with phpmyadmin but it still dosn't show it also i am using older version of mysql 3.23.58


  • you should really be using SSH for the best result.


  • You are having a problem dumping? Or restoring?

    Where are you hitting the 2mb limit?


  • this is what commend i am trying in terminal
    mysql -u user -p pass database_db then i check database with phpmyadmin but it still dosn't show it also i am using older version of mysql 3.23.58
    I thought you was asking for help dumping a DB, that command is for importing a DB. I see you missed a space after the <, but could of been a typo in your post.

    Dumping a DB
    mysqldump --opt -u username -p dbname > /path/to/save/db.sql

    Importing a DB
    mysql -u username -p dbname < /path/to/file/db.sql

    I dont think ive ever seen a host set a 2mb limit on a dump or import thru myphpadmin, but who knows now a days. :eek:







  • #If you have any other info about this subject , Please add it free.#
    Your name:
    E-mail:
    Telphone:

    Your comments:


    If you have any other info about Help on MySql Dump on Linux Fedora 2 , Please add it free.

    badpoolerror.com | 9.01.2009 15:38 | edit