Error on trying to do anything from website edits in database

[Shadow_]

Database imported is not working properly like it did on windows ( exported it using phpmyadmin )
--EDIT
on creating account or doing any edit for the database nothing happens + gives error like this

string(161) "INSERT INTO `accounts` (`name`, `password`, `email`, `creation`) VALUES ('hsdjasdak', '54c2323840c7d68b1b477d6aacd23eaa7f4b270e', '[email protected]', '1546716709')"
(query - SQL error)
Type: voidQuery (voidQuery is used for update, insert or delete from database)

Field 'id' doesn't have a default value

and when i imported the sql file it doesn't have auto increment or "id"
Thank you for reading.

 

[Don Daniello]

Try this: How do I ask a good question? - Help Center (https://stackoverflow.com/help/how-to-ask)

 

[Shadow_]

Try this: How do I ask a good question? - Help Center (https://stackoverflow.com/help/how-to-ask)

i don't think that you need more information that i have written
-- First i had windows vps and i have made a back up of the uniserver files and openned it on my pc to keep the files of the database then i made backup using export in phpmyadmin which gives error every action taken from website connects with database ( insert actions ) , thats all

 

[Don Daniello]

Have you thought about the possibility that the error messages contain useful hints about what the problem is and allow you to solve it?

The main point here is that you should post the error.

 

[Shadow_]

Have you thought about the possibility that the error messages contain useful hints about what the problem is and allow you to solve it?

The main point here is that you should post the error.

my main problem is that i want to know the best way to export and import database from windows to linux because i tried copying and pasting MYI,MYD,frm,ibd, files and didn't work when i try to browse any table from phpmyadmin once i click on it it says this table doesn't exist idk why or what is happening, also tried export and import using phpmyadmin page and tried mysqldump and when i tried to add them i recieved that error

#1030 - Got error 168 from storage engine

and AUTO_INCREMENT is not added to the id columns same with the keys

 

[Don Daniello]

What options did you select when exporting via phpMyAdmin? The best way would be:

mysqldump databasename -r databasename.sql

 

[Shadow_]

the database is in windows so how to execute this command please?

What options did you select when exporting via phpMyAdmin? The best way would be:

mysqldump databasename -r databasename.sql

 

[Don Daniello]

For example by using this tutorial: Using mysqldump to backup and restore your MySQL database/tables (https://blog.winhost.com/using-mysqldump-to-backup-and-restore-your-mysql-databasetables/)

If it doesn't work, search for a different one. I didn't try it.

 

[Shadow_]

For example by using this tutorial: Using mysqldump to backup and restore your MySQL database/tables (https://blog.winhost.com/using-mysqldump-to-backup-and-restore-your-mysql-databasetables/)

If it doesn't work, search for a different one. I didn't try it.

i will try it and tell you anyway , but you didn't try before to change database from pc to another ?

 

[Don Daniello]

i will try it and tell you anyway , but you didn't try before to change database from pc to another ?

No, I didn't try following that tutorial. Good luck though.

 

[Shadow_]

No, I didn't try following that tutorial. Good luck though.

Just done did reinstalled ubuntu 16.04 and added new phpmyadmin, mysql, php and apache2 then did as the forum said exactly the database exported and imported it normally but when i tried to create account i found this :
you can check try CarcooIzx OT (http://carcooizx.zapto.org)

string(161) "INSERT INTO `accounts` (`name`, `password`, `email`, `creation`) VALUES ('hsdjasdak', '54c2323840c7d68b1b477d6aacd23eaa7f4b270e', '[email protected]', '1546716709')"
(query - SQL error)
Type: voidQuery (voidQuery is used for update, insert or delete from database)

Field 'id' doesn't have a default value

edit : i think the error because AUTO_INCREMENT is not added :

 

[Don Daniello]

Set it to auto increment. That means your database export/import went mostly fine though.

 

[Shadow_]

Set it to auto increment. That means your database export/import went mostly fine though.

when i do its send this error :

 

[Jacobs]

MySql can't make column auto_increment (https://stackoverflow.com/questions/5402949/mysql-cant-make-column-auto-increment)

 

[Shadow_]

Thank you guys for wasting time helping me , just beginner is linux just knew it from 2 days and i had to use it thank you anyway my problem is solved @Don Daniello @Jacobs