Monday, April 2, 2012

Linux MySQL kroz terminal?

Kreiranje i upload MySQL baze podataka:

mysql -u root -p -e ‘create database mydatabase’
mysql -u sales -p mydatabase < mydatabase.sql

Brisanje MySQL baze podataka:

show databases;
rop database mydatabase;

Eksportovanje baze podataka:

mysqldump -u {database_username} -p {database_name} > mysqlbackup.sql

1 comment:

  1. Different machines use various strategies to work with completely different materials based mostly on what every sector wants for its parts. Other firms decide to work with professional CNC machining companies to make their parts. CNC machining has allowed these industries to turn into more efficient at mass-producing customized best bike helmet brand CNC parts. CNC machining can be utilized for broad variety|all kinds} of materials, with the most common being aluminum, metal, brass, ABS, Delrin, and nylon.