mysqldump -h mysqlhost -u username -p mydatabasename > tgdbdump.sql
Home »
MySQL-Interview-Questions
» Use mysqldump to create a copy of the database?
Use mysqldump to create a copy of the database?
PMA05:25
Categories: MySQL-Interview-Questions
Related Posts:
Relational Databases-MySQL MySQL is a relational database. An important feature of relational systems is that a single database can be spread across several tables as opposed to our flat-file phone book example. Related data is stored in separat… Read More
Data Manipulation Language (DML) statements ? Data Manipulation Language (DML) statements Allow you to modify the contents of tables. There are three DML statements: INSERT Allows you to add rows to a table. UPDATE Allows yo… Read More
What’s the default port for MySQL Server? 3306 … Read More
Restore database (or database table) from backup? [mysql dir]/bin/mysql -u username -ppassword databasename < /tmp/databasename.sql … Read More
MySQL Subqueries? You can use the result of a query like you use a list of values with the IN operator to filter a query based on the result of another query. The subquery appears in parentheses after the IN keyword. The following query f… Read More
total number of rows? mysql> SELECT COUNT(*) FROM table; … Read More
Show unique records mysql? mysql> SELECT DISTINCT column FROM table; … Read More
What Is SQL? The Structured Query Language (SQL) is the most common way to retrieve and manage database information. An SQL query consists of a series of keywords that define the data set you want to fetch from the database. SQL uses… Read More
How set a root password if there is on root password? # mysqladmin -u root password newpassword … Read More
Data Control Language (DCL) statements ? Data Control Language (DCL) statements Allow you to change the permissions on database structures. There are two DCL statements: GRANT Allows you to give another user access to your database st… Read More
Data Definition Language (DDL) statements? Data Definition Language (DDL) statements Allow you to define the data structures, such as tables, that make up a database. There are five basic types of DDL statements: CREATE Allows you to cr… Read More
What is SERIAL data type in MySQL? BIGINT NOT NULL PRIMARY KEY AUTO_INCREMENT … Read More
what is Triggers? A trigger is a stored database object that contains a series of SQL commands, set to activate automatically when certain events take place. Each trigger is associated with a table. You can create a trigger that will fire… Read More
What Is a Relational Database? The basic concepts of a relational database are fairly easy to understand. A relational database is a collection of related information that has been organized into structures known as tables. Each table contains rows th… Read More
Use mysqldump to create a copy of the database? mysqldump -h mysqlhost -u username -p mydatabasename > tgdbdump.sql … Read More