Tag Info

New answers tagged

0

There is no shortcut for this type of navigation. The reason is that the tab key (which is the normal navigation key) is allowed + consumed in the SQL editor. This is usually always so in text editors. Only simple (one line) edits do not eat the tab char and hence allow to navigate by that.


0

There could be following two ways of doing the same. First is you take unloads from source using following command select * from table_name into outfile 'file_path' FIELDS TERMINATED BY ',' enclosed by '"' ; Then on target you can do following load data local infile 'file_path' into table table_name(Column_list_comma_seprated) FIELDS ...


0

There is a one worker per table limitation, so the maximum number depends on the number of tables you are migrating. Notes: A decent maximum is the number of cores on your system If you specify a large number but have fewer tables, then only the needed threads will be launched If the network saturates, like maybe 20 tables with 20 workers, then the copy ...


-1

http://bugs.mysql.com/bug.php?id=66609 MySQL workbench does not support "Migration from Oracle DBs is not supported: http://dev.mysql.com/doc/workbench/en/wb-migration-database-concepts.html"


0

I had a similar problem, and this may be obvisous, but check you firewall rules in AWS. I have an IP range set, to restrict connections from the outside world. And the IP at my office changed, so it got outside the IP range. My colleague in another ofice could still connect, so I thought the problem is on my PC, but the problem was with the firewall rules in ...


0

We just encountered this error. The issue was that the table was using MyISAM. Syntax of the SQL is ALTER TABLE t1 ENGINE=InnoDB;



Top 50 recent answers are included