Hello:
How would I save a table from mysql to my desktop using mysqldump? I did this but I dont get the option to save it.
mysqldump db18 News > news.sql
any help would be great
if you are doing it command line, it will just do it, it won't ask you anything, so you use
c:\path\to\desktop instead of just news.sql
where would it save the news.sql to? I want to import it to another database.
do you have access to phpmyadmin, if not download it, this will do everything you want, be sure and get the newest version
yes i have phpmyadmin but i would like to know how to do it via command line.
you may want to look at these two pages
http://www.mysql.com/doc/en/mysqldump.html
http://www.mysql.com/doc/en/mysqlimport.html
I have looked there and its not that much help! All I want to know is how to get that sql file onto my machine.
you mean you are telneting into a machine and want to command line save a mysqldump onto your machine, don't think that will work
you will just have to ftp the .sql file off the server, once you run the mysqldump
ok so where would mysqldumb save the sql file? thanks for your help
