Solved Database Backup how to readd it?

[Printer]

Hello,

Linux Debian 64bit

Lighttpd

My server had trouble yesterday and i have copy the mysql folder which includs the database and also i export sql on all tables. How can i reupload them?


Thanks!

 

[Ninja]

I assume that you would like to import the sql to your database?

mysql -u [COLOR=#ff0000]root[/COLOR] -p -h localhost [COLOR=#ff0000]databaseName[/COLOR] < [COLOR=#ff0000]fileName.sql[/COLOR]

 

[Printer]

I have no idea, since i going to reinstall my dedicate, i copied the folder named mysql which have my old database and also exported the tables to sql. Which one should i use the folder or the sql file to upload?

 

[Ninja]

You should just upload the sql file if that's where all the existing tables exist.

 

[Printer]

I think so, im not 100% sure myself. Since on linux everything is so sensetive one misstake and whole mysql is fuckt up :/ But thanks anyway, ill try then

- - - Updated - - -

Ok i got this now :S
You probably tried to upload too large file. Please refer to documentation for ways to workaround this limit.

 

[Ninja]

That's why you execute that code I wrote above in PuTTY and not phpMyAdmin.

 

[Printer]

Ah, but i wanted to make a test on my windows comp

But i hope i made a right backup of the base, Just question i did right. First i logged in phpmyadmin then selected my base and click export checked all tables and clicked sql and go button then i saved the sql file. Is that right?

 

[Ninja]

Yep, that's correct.

You could also use mysqldump to export your database in Debian.

 

[Printer]

Ok thanks Ninja Rep I will try it soon until the reinstall is done

- - - Updated - - -

Seems i already repped you