Here a simple script to backup all your mysql database on a remote FTP server. The script weekly overwrite the backup so you have full backup of your DBs for the last 6 days and your FTP server doesn't run out of space. #!/bin/sh BACKUP="/path/to/temp/dir/$$" DAY=$(date +"%a") ### MySQL Setup ### MUSER="root" [...]
If you have access on the machine with MySQL and you need to export all tables in a database you can use: hpatoio@namazu:~$ mysqldump -uroot -p DATABASE_NAME -T '/home/simone/export_csv' –fields-terminated-by "," –fields-enclosed-by '"' –lines-terminated-by "\n" the script will create a files for each table of the DB and will place it in export_csv. If you [...]
Amazing online tool to convert MDB Microsoft Access file to MySQL SQL scripts ! Check it out -> http://www.mdb2mysql.com/
Oh no ! It happend again !! The sysadmin turned on the gpc_magic_quotes and you got the DB full of \' Here a fast way to get back the correct values. UPDATE table_name SET field_name = REPLACE(field_name,'\"',"")
For security reason, MySQL doesn't allow access from other computer. If you try to connect with a MySQL administration client like MySQL Administrator you will get a Mysql Error Number 2003. All this operations modify system settings, so they must be executed with root privileges If you want connect from a computer in your LAN [...]