Home |  MySQL Buzz |  FAQ |  Feeds |  Submit your blog feed |  Feedback |  Archive |  Aggregate feed RSS 2.0 English Deutsch Español Français Italiano 日本語 Русский Português 中文
Showing entries 1 to 3

Displaying posts with tag: webhosting (reset)

MySQL Security Best Practices
+0 Vote Up -0Vote Down

If you install a MySQL Database Server with the default options, your data are insecure and your server is in risk of invasion and some performance issues will appear shortly. With some best practices, your MySQL database becomes secure and the performance goes well. 1 – Set root password and change its login name As... Read More

The post MySQL Security Best Practices appeared first on Devops for Dummies.

Export and Import MySQL Databases
+0 Vote Up -0Vote Down
When you have a MySQL server in production, backups are necessary to protect your data against any problem that may occur with your server. To make the backup and to restore the data, Exporting to a dump file The operation of export is also called dumping. To carry out the exporting, use the command msyqldump […]
Probably the worst way to deal with a stuck query...
+1 Vote Up -1Vote Down
is to disable a customer's account for more than 24 hours without any warning whatsoever. This happened to one of my accounts and I'm beyond furious at the database and network administrators of HostGator.com. Seriously, guys, I don't know of a more unprofessional way of dealing with a stuck query.
Showing entries 1 to 3

Planet MySQL © 1995, 2014, Oracle Corporation and/or its affiliates   Legal Policies | Your Privacy Rights | Terms of Use

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.