Critically important! Save! How to transfer innoDB database from one computer to another? Exported the file using Server -> Data Export. The result is a 1 sql file, but when importing to another computer (Server -> Data Import), an error 1146 occurs (talbe doesn't exist). Found this stuff

It says about some ibdata and .frm files, but where can I get them? Help! Tomorrow the database should be shown to the teacher!

Here is how I exported the base: enter image description here

Advanced options are not changed.

If you export without Include Create Schema, then error 1142 occurs: SELECT, LOCK TABLES command denied to user 'root' @ 'localhost' for table 'accounts'

If you import a single structure, an error 1022 will occur: no database selected.

  • Through a backup on the old server and restore on the new. Other methods are more complicated and require certain knowledge and qualifications. P.S. InnoDB there are tables, but not a DB. - Akina
  • @Akina, and how to do it? What options in Workbench reap? Good evening, by the way! - Dmitry Moskovchenko
  • stackoverflow.com/q/17190083 which option did you choose when exporting the database? - Kosta B.
  • @KostaB. the first. - Dmitry Moskovchenko

1 answer 1

If you need to transfer information from the tables, I can suggest mysqldump

To get the table:

 mysqldump -u USERNAME -p DATABASE table > table.sql

On another computer:

 mysql -u USERNAME -p DATABASE < table.sql
  • Desirable and tables, and information. The program opens and closes immediately. And how does it differ from Data Export in Workbench? - Dmitry Moskovchenko
  • She and the table and information takes. The command makes a table dump. The dump will contain a set of SQL commands for creating and populating tables. - NTP
  • It turned out in the standard way (Server -> Data Import) to transfer the structure with procedures. I had to enter the data myself. Well, thanks for that! - Dmitry Moskovchenko