|
|||||||||
|
|||||||||
|
|||||||||
| |
|||
 |
|
|
|
|
|||||||||
|
|||||||||
|
|||||||||
| |
|||
|
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Display Modes |
Dev Articles Community Forums Sponsor:
|
|
Stay one step ahead of the competition. Evaluate and give feedback
on some of the hottest web development tools on the market today.
Make your opinion heard! Click
Here
|
|
#1
February 2nd, 2003, 02:00 AM
|
|||
|
|||
|
backing up my tables
Hi all,
can some one help me back up my tables in MySQL. I want to format my computer, but first, I need to get my tables off the computer and plant them on another compter. any thoughts? thanks, Qutaibah
|
|
#2
February 2nd, 2003, 03:05 AM
|
|||
|
|||
|
try phpMyAdmin ..
http://www.phpwizard.net/projects/phpMyAdmin/
|
|
#3
February 2nd, 2003, 01:54 PM
|
|||
|
|||
|
command line
Thanks MERSAL for your response,
I I was thinking of using the command line. is there a way where I can back up my MySQL table from my shell account. thanks Qutaibah
|
|
#4
February 2nd, 2003, 11:07 PM
|
|||
|
|||
|
Hey buddy,
Just use the handy mysqldump application. If you have the mysql client tool in your path, you should have mysqldump as well. At your command prompt, or in your script, just type this: mysqldump -h <ip or domain> -u <username> --password=<your_password> <dbname> <tablename> > <FileToStoreItIn> For example: mysqldump -h 192.168.0.150 -u root --password=badpassword test test_table > testdb.sql or just leave out the table name to get the whole database Hope this helps -- Wil Moore III, MCP wil@wilmoore.com www.laidbak.net
|
|
| Viewing: Dev Articles Community Forums > Databases > General SQL Development > backing up my tables |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
