Ads were blocked - no problem. But keep in mind that developing HeidiSQL, user support and hosting takes time and money. You may want to send a donation instead.

Copy Database

Nazmul Hasan Nero's profile image Nazmul Hasan Nero posted 8 years ago in Import/Export Permalink
How can I copy entire database. when i right click on database i can found "copy" menu. but where is paste menu?
Nazmul Hasan Nero
kalvaro's profile image kalvaro posted 8 years ago Permalink
Edit/ Paste (Ctrl+V). But you cannot use the clipboard to copy a complete database, just its name. Please use the "Export database as SQL" feature instead ("Tools" menu or context menu on left tree).
timtak's profile image timtak posted 1 month ago Permalink

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.

1 attachment(s):
  • 2021-04-12-13-04-49
timtak's profile image timtak posted 1 month ago Permalink

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.

timtak's profile image timtak posted 1 month ago Permalink

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?

timtak's profile image timtak posted 1 month ago Permalink

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.

ansgar's profile image ansgar posted 1 month ago Permalink

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.

timtak's profile image timtak posted 1 month ago Permalink

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.

Please login to leave a reply, or register at first.




Ads were blocked - no problem. But keep in mind that developing HeidiSQL, user support and hosting takes time and money. You may want to send a donation instead.