[Rehan]

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.

A lot of thanks dude problem has been solved ( via terminal import ).Also i just ignored that error in phpmyadmin and that is working now. 

[Mashiro]

Well, I'm glad that you finally found something that works out for you. On the other hand, ignoring a issues is not a solution to the issue .