update tablename set column_name = replace(column_name, ‘find string to replace’, ‘replace with this string’);
Forr example, if you have asterisks in your data you want to delete:
update cities set city = replace(city, ‘*’, ”);
At the SSH Unix / Linux prompt type:
mysqldump -u username -p databasename | mysql -u username -p database
You will be prompted to enter each database password.
the first mysql database will be copied to the 2nd mysql database.
Make sure you have already set up the database name and username and password before you attempt this.
From the Linux shell prompt via SSH type:
/usr/bin/mysql –user=schoolco_scott –password=scott08 –database=schoolco_schoolco –table=temp_image < /home/schoolco/public_html/image.sql
In order to run MYSQL from the command line on your web server, you need SSL enabled for your account.
With a shared web hosting account, you do not have root access, so you will need to contact your host to make sure they can enable SSL. It will probably be Jailed SSL.
If you do not [...]
log into MySQL
$ mysqldump -u username -p databasename > database.sql
You will be prompted for your mysql password. Your database will be backed up to the file named database.sql. Note you can name the database file anything you choose.
