MySQL Techniques
To take the dump of a table
mysqldump --quick Database Table > /tmp/Table.sql
Upload a file with insert statements:
mysql --user=root --database=Db --quick < /opt/apps/text.txxt
Start mysql server
Set the following parameters:
MYSQL_UNIX_PORT=/opt/apps/test/mysqld-new.sock
MYSQL_TCP_PORT=3307
mysql_safe --port=3306
MySQL Replace(), here's the syntax.
update [table_name] set [field_name] = replace([field_name],'[string_to_find]','[string_to_replace]');