SitePoint Sponsor

User Tag List

Results 1 to 4 of 4

Thread: mysql dump

Hybrid View

  1. #1
    SitePoint Enthusiast raynebair's Avatar
    Join Date
    Dec 2000
    Location
    Alabama
    Posts
    91
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    mysql dump

    ok, I've been reading the threads about mysql and ssh. What is the difference between running mysql dump from the command line and using the dump feature in phpmyAdmin?

  2. #2
    Making a better wheel silver trophy DR_LaRRY_PEpPeR's Avatar
    Join Date
    Jul 2001
    Location
    Missouri
    Posts
    3,428
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    mysqldump works and phpMyAdmin doesn't.
    - Matt ** Ignore old signature for now... **
    Dr.BB - Highly optimized to be 2-3x faster than the "Big 3."
    "Do not enclose numeric values in quotes -- that is very non-standard and will only work on MySQL." - MattR

  3. #3
    SitePoint Enthusiast raynebair's Avatar
    Join Date
    Dec 2000
    Location
    Alabama
    Posts
    91
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Could you explain further? I've used the dump in phpMyAdmin and I was able to run that same script on another database to re-create the table...it worked like a charm. So I don't understand what the difference is...does it generate different script?

  4. #4
    Making a better wheel silver trophy DR_LaRRY_PEpPeR's Avatar
    Join Date
    Jul 2001
    Location
    Missouri
    Posts
    3,428
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    try it with a 50MB+ database. i've also seen phpMyAdmin mess up quotes in the data (not escaping them correctly), which is unacceptable. mysqldump works every time, the first time. using it, and mysql to import, is just a lot more efficient than using phpMyAdmin, too -- especially as the database gets bigger.


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
  •