Computing.Net > Forums > Database > Saving SQL Database

Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to start participating now! Also, be sure to check out the New User Guide.

Saving SQL Database

Reply to Message Icon

Name: tpasi
Date: June 6, 2006 at 16:50:52 Pacific
OS: Windows2000
CPU/Ram: 256
Product: compaq
Comment:

Is there a way to save sql database on a floppy disk or hardrive. What command can I use.

Is there a way where I can save my newly created SQL database on my hardrive or floppy disk. If so please help me



Sponsored Link
Ads by Google

Response Number 1
Name: jhunt303
Date: June 7, 2006 at 02:20:50 Pacific
Reply:

A little open ended, but I'll give you an example anyway:

For mySql

mysqldump -u root -pPassword -x --all-databases > dump.sql

Will create a dump file that is effectivley a create SQL statement for all your data, this can be done with many databases, all in slightly different ways


0
Reply to Message Icon

Related Posts

See More







Post Locked

This post is quite old and has been locked from receiving new replies. Please create a new posting instead.


Go to Database Forum Home


Sponsored links

Ads by Google


Results for: Saving SQL Database

SQL, Database, and RDBMS questions www.computing.net/answers/dbase/sql-database-and-rdbms-questions/717.html

Query for SQL Database www.computing.net/answers/dbase/query-for-sql-database/231.html

SQL DB Owner www.computing.net/answers/dbase/sql-db-owner/42.html