The following line will allow you to dump a MySQL database from the current machine to another machine, for as long as you have access to the dd command on the remote machine: mysqldump -u USERNAME-HERE -p’PASSWORD-HERE’ DB-NAME-HERE | ssh [email protected] “dd of=/mysql/$(date +’%d-%m-%y’)”
How to check if a table exists in the current MySQL database, through running a simple query.
This SQL query will search for a specific keyword in all the stored procedures available.
The query below will replace all occurences of “Bob Loblaw Law Blog” found in the field “BlogName” field of the Blogs table. All instances of the string are being replaced, and the search is case sensitive. The function is also multi-byte safe.
In case you forgot the root password for your MySQL database server running under Microsoft Windows, you can still access your database and even reset your password using the command prompt. However, first you should check your my.cnf file where your password is stored. If you are using a new version of MySQL Server, such […]