From personal use

• SHOW DATABASES; SHOW TABLES; ...
• mysql -u username < script.sql
• GRANT ALL PRILIVEGES on sphinx.* TO sphinxsearch@localhost;
• CREATE database 'sphinx';
• CREATE USER 'sphinxsearch'@'localhost' IDENTIFIED BY 'some_pass';
• innodb disabled makes a much lower memory footprint
• help : the MOST important command ;)

Official documentation

• http://dev.mysql.com/doc/

To explore

• replace linkchecker sqlite usage to MySQL

See also

• SQLite

---

Note

My notes on Tools gather what I know or want to know. Consequently they are not and will never be complete references. For this, official manuals and online communities provide much better answers.

RSS for this page only
RSS for the entire wiki

• HomePage

CONTENT

• Cookbooks
• Reading Notes
• Events
• Tools
• Languages
• Housing project

CONTACT

• Email
• Facebook
• Skype
• VoIP
• Twitter
• IRC
• FOAF

UPDATES

• Recent changes

LAST TWEET

• utopiah: merde j'ai encore loupe une opportunite http://t.co/4FXQnBF6

RIGHTS

• content
  
• code
  
• artwork
  

Type here your remark. Eventually add your contact information. Send feedback about
My SQL

If you can read this text (opacity=0.08) if means the page has not been edited for a long time. Consequently the information it holds might be deprecated or no longer represent the opinion of this author.