This page shows information about a web page, and who has bookmarked it and when
http://www.tech-geeks.org/contrib/mdrone/mysql-stuff/mysql-cheatsheet.html
These are the public entries for this link:
- Handy Cheat-Sheet of MySQL Commands
From your login shell... # Creating a Database # mysqladmin create [databasename] Example: # mysqladmin create mydatabase [Enter] # Dropping (Removing) a Database # mysqladmin drop [databasename] Example: # mysqladmin drop mydatabase [Enter] # Populating an Existing Database from a *.sql File # mysql [databasename] < [databasedumpfile.sql] Example: # mysql mydatabase < mydatabase.sql [Enter] # Dumping Database Structure and Data to a *.sql file mysqldump --opt [database] > [databasefilename.sql] Example: mysqldump --opt techmanual > techmanual.sql; From within the MySQL interface... # Starting MySQL from the Command Line # mysql Example: mysql [Enter] You will be welcomed with the following message: Welcome to the MySQL monitor. Commands end
By emweb in Public bookmarks with mysql tipsntricks
NB: The average rating is calculated using the rating for both public and private entries for this link.