BoxSlots.com - Unmetered 100Mbit/1Gbit/2Gbit VPS from ?10.99/month (Netherlands)

[doom2011]

When everthing will get back online?
Give us a precised date/time

[proxy]

my last backup date of 4 days but remain in the disc of the server

if the client is not good webmaster

boxslots ais did not he should ensure their safety and our security

[rohan123]

in SSH do this

mysqldump --opt -u user -p dbname > {path}/backup.sql

at least you should give your 10 minutes in a week to have backups of ur site

[michaellin85]

where does it save the back up to?

in SSH do this

mysqldump --opt -u user -p dbname > {path}/backup.sql

[rohan123]

for example do this

mysqldump --opt -u user -p dbname > {path}/backup.sql

if you have cpanel installed then it will be like this

mysqldump --opt -u cpanelusername -p mysqldbname > /home/cpanelusername/public_html/backup.sql

so if ur cpanel username for ur site is michael then it would be like this

mysqldump --opt -u michael -p michael_dbname > /home/michael/public_html/backup.sql

and u will get the backup saved into the root of ur site

u can change the path to whatever u want

[michaellin85]

thank you, after i do that i can save the file somewhere else. what do i do if i want to restore from a backup?

[doom2011]

when everything will bac online, we are tired from waiting

[rohan123]

thank you, after i do that i can save the file somewhere else. what do i do if i want to restore from a backup?

for restoring use this

mysql -u user -p dbname < {path}/backup.sql

replace the user with the user of where u want to restore the db

replace dbname with the dbname u have created where u want to restore

replace path with the path of the database backup file (.sql file) ( u need to put it into ur server )

----

so if u have created new user in cpanel named "michael" and created a db with name "michael_db" and put the backup file in ur site's root and ur backup file's name is backup.sql then u will use this command..

mysql -u michael -p michael_db < /home/michael/public_html/backup.sql

[lellouchftw]

Why the fuck didn't you have a back-up of your own data? Christ, it's like the pot calling the kettle black.

Lol I did of course.

But it still takes me around 6 hours+ to get the VPS back to normal, quite a pain.

Anyway hoping it'll run smoothly now.

[charmed]

Well, it took me few hours to restore everything too. Including kloxo settings. But boxslots helped me a lot. Bharat installed kloxo for me because I somehow couldn't make it through (my stupidity). Zack and Ricky are both great too. I haven't got chance to meet with Cameron through tickets yet.

doom2011, have you got new VPS details already?