Tag: MySQL

In MSSQL, you can use the SELECT statement to retrieve data from one or more tables, and assign the result to a variable. The syntax for assigning the

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

By default when you want to import sql file size is 2MB in PHPMyAdmin. That is PHP’s file upload limit. To change maximum import file size do following

Configuring MySQL to listen to localhost only is a great way to secure your data from malicious attacks. This guide will help you to understand how you can

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 <

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,

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 [box type=”warning”] Don’t put space after

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

To damp all MySQL databases, use the –all-databases option. mysqldump -u username –p password –all-databases > dump.sql

For exporting MySQL database’s only the data, use –no-create-info option. The dump will not re-create the database, tables, fields, and other structures when importing. mysqldump -u username -ppassword