Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
save a mysql database
- Thread starter cnw40007
- Start date
at prompt
if you are using linux
/usr/bin/mysqldump -u root -psomepassword database_name > /mnt/floppy/dumpfilename.sql
if you are running MS
c:\mysql\bin\mysqldump -u root -psomepassword database_name > a:\filenale.sql
Bye
Qatqat
The reason why my girlfriend can read my thoughts is because mine are properly written! (G.Lepore)
if you are using linux
/usr/bin/mysqldump -u root -psomepassword database_name > /mnt/floppy/dumpfilename.sql
if you are running MS
c:\mysql\bin\mysqldump -u root -psomepassword database_name > a:\filenale.sql
Bye
Qatqat
The reason why my girlfriend can read my thoughts is because mine are properly written! (G.Lepore)
- Thread starter
- #3
danielhozac
Programmer
How do you connect to the other machine? SSH, FTP, NFS or what? //Daniel
Do you mean How to import it into another machine?
move the file across. Save it into any directory
let's assume /tmp
if your file is called dbfile.sql
then log on like this
/usr/bin/mysql -u root -pyourpassword database_name < /tmp/dbfile.sql
Bye
Qatqat The reason why my girlfriend can read my thoughts is because mine are properly written! (G.Lepore)
move the file across. Save it into any directory
let's assume /tmp
if your file is called dbfile.sql
then log on like this
/usr/bin/mysql -u root -pyourpassword database_name < /tmp/dbfile.sql
Bye
Qatqat The reason why my girlfriend can read my thoughts is because mine are properly written! (G.Lepore)
- Status
Similar threads