Need help restore DB

[Ch3tos]

Hello ,

I got a backup of the database and then reinstalled Cpanel,
now I have a problem importing the database

can anyone help please

 

[Owen34]

How big is the file? Can you edit it and remove everything upto this line (and including) then carring on importing.

You can look at the table and see what id it got upto.

 

[Ch3tos]

60MB, any another way i don't understand ?

 

[Owen34]

60MB is easily worked on in a txt editor.

See the chars in your pic above in the ' ' search for that word in the sql file, then the 2nd occurance then remove everything before that line & remove that line & continue the import with the file.
Make sure you still have the orignal full file before editing the data out.

 

[Ch3tos]

there is many

 

[Owen34]

This text

https://i.imgur.com/sc0g9TA.png

 

[Ch3tos]

there is many too

 

[Owen34]

from your image of the sql file , you only have 1 insert for tags, remove lines 4699 - 4704 so there is no insert.

But.. your following image shows other data, so it doesnt make sense atm.

I could fix the file tomorrow in 10 minutes if you have trust, I am a new member here but have 20 years experiance.

 

[Ch3tos]

yes please if you can help

 

[BattleKing]

Hello ,

I got a backup of the database and then reinstalled Cpanel,
now I have a problem importing the database


View attachment 36387

can anyone help please

Ch3tosYou just need to check in the backup file for INSERT INTO `xf_tag.tag`

Check if there are multiple lines with your text which is shown in the picture above, if there are multiple lines for that compare them and decide which one to delete.