July 18th, 2000, 02:54 PM
i made a backup of a databse into a file.sql file, but how can i use this ?
i would like to make a backup database with this file, but how do i do this? what other usages are for the files with sql extension?
thanks for the info
July 18th, 2000, 03:11 PM
sql files usually contain a bunch of sql commands to recreate the database. to load this sql file back into a database, you can use
mysql -uuser -p database_name < yourfile.sql
that's assuming the database is already created.
July 19th, 2000, 12:49 AM
cool, thanks a lot for the help.