Ubuntu – find .SQL files on Ubuntu Server

migrationMySQLUbuntuweb-server

I am migrating web servers. I'm kind of stuck on migrating the MySQL databases. I was wondering where to find the .SQL files, that I need for migration, under Ubuntu Server. I think the .SQL files are the only ones I need. I will be doing the migration with FTP and SSH. Any help would be greatly appreciated.

Best Answer

MySQL doesn't store data as .sql files. It stores data as either MyISAM or InnoDB files, which are usually stored in /var/lib/mysql.

If you need to export to SQL files, you can do so with the mysqldump command.

Related Solutions

Linux – find the include files for MySQL on Linux

$ mysql_config --include

On my system, this prints -I/usr/include/mysql

If the directory revealed by mysql_config doesn't have the right include files, your installation may have been partial or may have been altered after the fact.

From the documentation:

mysql_config provides you with useful information for compiling your MySQL client and connecting it to MySQL....

--include

Compiler options to find MySQL include files.

Mysql – How to do an “insert” statement from MS SQL -> MYSQL using linked servers

So long as the permissions are set up properly you should be able to an INSERT just fine. Make sure that the user context that is connecting through the linked server to MySQL has the proper permissions on the table in your MySQL server.

To see the security settings for the linked server

Expand Server Objects in SQL Server Management Studio's Object Explorer
Expand Linked Servers, right-click on the linked server in question and get properties.
Click Security on the Linked Server Properties page and verify the security mappings.

Best Answer

Related Solutions

Linux – find the include files for MySQL on Linux

Mysql – How to do an “insert” statement from MS SQL -> MYSQL using linked servers

Related Topic