The "Freeola Customer Forum" forum, which includes Retro Game Reviews, has been archived and is now read-only. You cannot post here or create a new thread or review on this forum.
Right I'm sure this is possible and I'm sure I've done it before but I just can't remember how.
I have a whole load of info in a database, I'm setting up the database at uni now and want to create and populate the database at uni with the data I have.
Have an SQL file that will create all the tables and enter all the data into the tables.
Now I'm sure there is a command that can be entered that will execute the sql file and carry out all the commands it contains.
Anyone know how?
I have a whole load of info in a database, I'm setting up the database at uni now and want to create and populate the database at uni with the data I have.
Have an SQL file that will create all the tables and enter all the data into the tables.
Now I'm sure there is a command that can be entered that will execute the sql file and carry out all the commands it contains.
Anyone know how?
Cheers
Will give it a try tomorrow.
Will give it a try tomorrow.
"mysql db_name < text_file"
Easier to do in mysqladmin.
Easier to do in mysqladmin.
Right I'm sure this is possible and I'm sure I've done it before but I just can't remember how.
I have a whole load of info in a database, I'm setting up the database at uni now and want to create and populate the database at uni with the data I have.
Have an SQL file that will create all the tables and enter all the data into the tables.
Now I'm sure there is a command that can be entered that will execute the sql file and carry out all the commands it contains.
Anyone know how?
I have a whole load of info in a database, I'm setting up the database at uni now and want to create and populate the database at uni with the data I have.
Have an SQL file that will create all the tables and enter all the data into the tables.
Now I'm sure there is a command that can be entered that will execute the sql file and carry out all the commands it contains.
Anyone know how?