Questions regarding the MySQL database server, client and tools.

learn more… | top users | synonyms

2
votes
2answers
3k views

Backup mysql from terminal

I have scheduled a cron job to backup mysql databases on ubuntu9.10. I used the following entries in the cron file. 37 4 * * * root /usr/bin/mysqldump -u root -p<mysql-password> --all-databases ...
7
votes
1answer
3k views

why would /etc/init.d/mysql run the wrong upstart job?

update: /lib/init/upstart-job has been replaced with the MongoDB init script. For some reason, /etc/init.d/mysql start|stop|restart|status (/etc/init.d/mysql is simply a symlink to ...
1
vote
1answer
220 views

Adding quotes to a string in a file

I currently have an SQL file filled with insert statements in the form: INSERT INTO database.table(primary_key, foreign_key, url_one, url_two, int_one, int_two, int_three) VALUES ...
22
votes
5answers
25k views

How to I move MySQL data files onto different partition?

I have my hard drive partitioned with two partitions, so I can easily re-install Ubuntu and try out different versions without losing my home directory data. It is setup like this: 20GB -> / ...
71
votes
12answers
15k views

What's the easiest way to set up a LAMP stack?

I set up a new VPS instance of Ubuntu and am wondering what the easiest way is to get up and running with a basic LAMP stack (i.e. which packages are required, which configuration options need to be ...