Currently Browsing: Databases

Install WEB server (LAMP) on Ubuntu with Firewall, Phpmyadmin and Firewall

Installing LAMP server Update source apt-get update Install Vim apt-get install vim Install tasksel apt-get install tasksel Install LAMP (with tasksel) type tasksel select LAMP and install Install phpmyadmin apt-get install phpmyadmin Install vsftpd apt-get install vsftpd Type vim /etc/vsftpd.conf Write...

[How To] Increase import file size in phpmyadmin

By default when you want to import sql file in phpmyadmin, in “File to Import:” section you can see (Max: 2MiB). That is php’s file upload limit. To increase it find php.ini file $ locate php.ini /etc/php5/apache2/php.ini /etc/php5/cli/php.ini...

[How To] Setup MySQL Listen on Localhost Only

If You want that MySQL listen only to localhost edit the MySQL configuration file and write bind-address=127.0.0.1 Configuration file can be /etc/my.cnf or /etc/mysql/my.cnf Next, you will need to restart the database server: $ sudo /etc/init.d/mysql...

How To Restore and Import MySQL Database

You should upload the dump file to the MySQL server, and type this command to import the databases into the MySQL server. mysql -u username –ppassword database_name < dump.sql Don’t put space after -p and then...

How to Online Backup Innodb Tables

Backup the database inevitable cause MySQL server unavailable to applications because when exporting, all tables acquired a global read lock using FLUSH TABLES WITH READ LOCK at the beginning of the dump until finish. So although READ statements can proceed, all INSERT, UPDATE and DELETE statements will...

How to Export, Backup Or Dump A MySQL Database

To export a MySQL database into a dump file, simply type the following command syntax in the shell. mysqldump -u username –ppassword database_name > dump.sql Replace username, password, database_name and dump.sql as your needs. All data, tables, structures and database of database_name will be backed up...

How to Export A MySQL Database Structure

If You need to export only the MySQL database’s tables’ structures use –no-data switch. mysqldump -u username -ppassword –no-data database_name > dump.sql Don’t put space after -p and then...

How to Dump Several MySQL Databases Into Text File

Use –databases option for exporting several databases. mysqldump -u username -ppassword –databases db_name1 [db_name2 ...]...

« Older Entries