All page names need to be in English.
en da  de  fr  it  ja  km  nl  ru  zh

Extension Development, MySQL

From TYPO3Wiki
Jump to: navigation, search

<< Back to Extension Development << Back to Developer manuals page


MySql install

Suppossed you have downloaded and install all the packages:


MySql start

mysqld_safe --user=root&

MySql changing password

/usr/bin/mysqladmin -u root password 'new-password'

MySql login

mysql -u root -p

MySql show all databases

show databases;

MySql create a database

create database foobar;

MySql import a database

mysql -p -h DBSERVER dbname < dbname.sql
where option -h is the server 

Restarting MySql

mysqladmin -u root -p shutdown
mysqld_safe --user=root&

Deleteing a database

drop database foobar;

--Chibox 15:52, 28 May 2008 (CEST)