heres the deal... .i have a decent sized mysql database that i dumped into a file not too long ago. i want to know if there is any way i can use the dump file without having to rebuild the tables all over again.... id really hate to key in 40 tables all over again... i read the dump file and theres sql statements there that creates the tables... im guessing theres a way to do this... somebody help?! thanks in advance
If the create table statements were dumped also, they should create the tables for you...
the database name is 'montegue' the sql file is 'main.sql'
i cant seem to figure it out...
thanks
The syntax to load from the dump file?
/path/to/mysql -u username -ppassword montegue < /path/to/main.sql
