Copy Database

Thank you.

Thank you. I am attempting to copy a database.

I exported a table as SQL. Then I went to a new database, loaded the SQL file from the file menu, and clicked on RUN ▶ The SQL appeared to run but no change was made to the new database nor to the old one.

Was this because the SQL attempts to create the tables in the old database, in which the tables already exist so nothing happens? I don't think so because the first command is CREATE TABLE IF NOT EXISTS adodb_logsql (

I am attempting to copy the eigo_20130403 database to eigo_2014 but after running the sql the eigo_2014a is still OB empty.

It is okay. I don't think that I need to copy the database this time. But perhaps others would like to know. I would like to know for future reference.

Oops, no I do need to copy a database.

Please would someone tell me how can I repopulate an empty database with the SQL that I have exported?

Sorry.

I exported a table as SQL. Then I went to a new database, loaded the SQL file from the file menu, and clicked on RUN ▶

The above method did recreate the database but it is a little bit smaller.

Your script looks ok to me, and after you ran it by click on the Run button, and perhaps a refresh on the database tab, you should see the created tables. At least if the script has run without errors. Watch out for errors in the log panel at the bottom.

Yes, sorry, thanks you: I forgot to press refresh!

The database has been copied, but a few tables are a bit smaller.

I have already run the SQL so the log errors seem to have disappeared.