[Mashiro]

for now i want to import database from my Windows system to ubuntu server via terminal is it possible?

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: (Select All)

mysql -u root -p

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

Code: (Select All)

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: (Select All)

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.