You can accomplish this using the mysqldump command-line function. For example: If it’s an entire DB, then: $ mysqldump -u [uname] -p db_name > db_backup.sql If it’s all DBs, then: $ mysqldump -u [uname] -p –all-databases > all_db_backup.sql If it’s specific tables within a DB, then: $ mysqldump -u [uname] -p db_name table1 table2 > … Read more
Here are a couple of things that could be preventing you from connecting to your Linode instance: DNS problem: if the computer that you’re using to connect to your remote server isn’t resolving test.kameronderdehamer.nl properly then you won’t be able to reach your host. Try to connect using the public IP address assigned to your … Read more
So you want to backup all your drive without all those nasty mistakes and also filter out all the /proc and other temporary folders? An option is to mount the root folder onto another folder within the filesystem, like this: $ cd /mnt $ mkdir drive $ mount –bind / drive This will give you … Read more
You can accomplish this using the mysqldump command-line function. For example: If it’s an entire DB, then: $ mysqldump -u [uname] -p db_name > db_backup.sql If it’s all DBs, then: $ mysqldump -u [uname] -p –all-databases > all_db_backup.sql If it’s specific tables within a DB, then: $ mysqldump -u [uname] -p db_name table1 table2 > … Read more
I’ve used Linode for about a year now, specifically their Dallas DC. I have nothing but praise for them. The only thing they could do to make me happier is to make it free (but with their referral program it’s been free for me for 6 months now!). I’ve blogged a bit about them: Linode … Read more