About SSH?

[aycan555]

Hi when i tryed to import my database with SSH, it gives me error below:

 ERROR 1062 (23000) at line 854685: Duplicate entry '38422' for key 1

How can i correct this problem?

[Darkblade]

Check out the link in my sig for backing up or restore your database via SSH. It should be helpful to you.

[Jerry]

Personally I edit the source and remove the keys from the source tables, I find this a lot when restoring some source databases from certain systems.

[aycan555]

But it is 140MB database how can i remove the keys?

[Jerry]

I usually use grep, though regardless of the size of the file there is only going to be a set number of CREATE statements for, if you can get the file onto your local machine you could use something like www.textpad.com and that is great with big files and then just search for the CREATE statements and delete the KEY definitions.

[aycan555]

There is PRIMARY KEY do i need to delete this is well? Also some tables got 3 keys, do i need to delete all?

[Jerry]

Personally I delete all of them when I do it, it doesn't make that much difference on small to medium boards as ImpEx does a select * so it table scans opposed to using the index, though on huge boards it can help.

For yours, I'd say just delete them all as the mission is to just get it working.