(03-12-2019, 12:04 PM)Hidden Refuge Wrote: That is certainly possible.

1. Backup the database on your Windows server into the .sql format (you can also compress it if you like).

2. Transfer the .sql file to your Linux server (extract it if you compressed it).

3. Start the MySQL command line and login as root:

Code:

mysql -u root -p

4. Create a empty database where you want to import the backup into:

Code:

CREATE DATABASE databasenamehere;

(Replace "databasenamehere" with your desired database name.)

5. Exit the MySQL command line with a simple "exit" command.

6. Import the database backup into the new empty database:

Code:

mysql -u root -p databasenamehere < databasebackupfile.sql

(Again remember to adjust database name and the database backup file name.)

7. Wait until the import is complete.


That's it actually. Works on MySQL and MariaDB.