At 4:32 PM -0400 9/12/07, tedd wrote:
So, what are my options? Any quick one line solutions? Nothing I've read address the problem I'm facing.
H said:
You'll need to use the mysql command line tools, mysqldump and mysql. Something like this: mysqldump -u username -p --database yourdatabase > yourdatabase.sql
I don't have access to a command line. But, I've tried this using php script, but the host has safe_mode on, which limits such activity.
- Jon said:
Normally if I don't need the entire DB (dev work) and can work w/ the last 100 records, I will end up doing something like:
That's a good idea. In this case, while I'm not touching the original database, my copy will be phased into the mix and thus needs to be complete.
-Rob said:
If you are using MySQL 4.1 or greater, the default mysqldump settings should work well.
I didn't say, but the MySQL version is 3 something and I don't have command line.
HOWEVER, I did find a solution, which was to have the host upgrade to a newer version of phpMyAdmin. From there, I was able to transfer larger tables.
Thanks to all who replied. I shall keep your suggestions. Cheers, tedd -- ------- http://sperling.com http://ancientstones.com http://earthstones.com _______________________________________________ New York PHP Community MySQL SIG http://lists.nyphp.org/mailman/listinfo/mysql NYPHPCon 2006 Presentations Online http://www.nyphpcon.com Show Your Participation in New York PHP http://www.nyphp.org/show_participation.php
