SitePoint Sponsor |
|
User Tag List
Results 1 to 4 of 4
Thread: mysql dump
-
Jan 24, 2002, 13:19 #1
- 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?
rayne
www.wifetalks.com
-
Jan 24, 2002, 21:11 #2
- 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
-
Jan 25, 2002, 13:14 #3
- 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?
rayne
www.wifetalks.com
-
Jan 25, 2002, 19:36 #4
- 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