Archive for the 'MySQL' Category

Backup Mysql Database on remote FTP Server

Monday, June 20th, 2011

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" [...]

CSV export from MySQL

Saturday, September 15th, 2007

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 [...]

Microsoft Access to MySQL | Online converter

Tuesday, September 11th, 2007

Amazing online tool to convert MDB Microsoft Access file to MySQL SQL scripts ! Check it out -> http://www.mdb2mysql.com/

Ops …

Sunday, October 8th, 2006

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,'\"',"")

Access Mysql from other machines

Tuesday, August 29th, 2006

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 [...]

Yes !