July 18th, 2000, 01: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, 02: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 18th, 2000, 11:49 PM
cool, thanks a lot for the help.