Extension Development, MySQL
From TYPO3Wiki
<< Back to Extension Development << Back to Developer manuals page
MySql install
Suppossed you have downloaded and install all the packages:
mysql_install_db
MySql start
mysqld_safe --user=root&
MySql changing password
/usr/bin/mysqladmin -u root password 'new-password'
mysql_install_db
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)
