Allow external connections to MySQL server on Plesk
May 27th, 2010
No comments
Comment out “skip-networking parameter” in /etc/my.cnf
Categories: mysql
Archive
Archive for the ‘mysql’ Category
Load a mysql database dump via command line
April 17th, 2009
No comments
Run this command on the command line to load a mysql database dump file
mysql -u yourusername -p -h localhost databasename < data.sql
Categories: mysql
How to dump a mysql database via command line
April 17th, 2009
No comments
Run this command to dump a database via command line
mysqldump –u yourusername –p yourdatabasename > yourdumpfile.sql
Categories: mysql