Interested to Buy Any Domain ? << Click Here >> for more details...
How would you backup and restore a big MySQL database? What
are the advantages of the approach which you have taken
over the others?
- 4 Answers
- 11187 Views
- I also Faced
- E-Mail Answers
Answer Posted / anil alpati
DATABAS DUMP - mysqldump -u <user> -p <password> <dbname> > filename
DATABASE RESTORE - mysql dbname< filename -u <user> -p <password>
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
How to escape special characters in sql statements?
What you can use regular expression for in mysql? Support your answer with an example?
What is the difference between database and table?
What is the use of i-am-a-dummy flag in mysql?
How many tables we can create in mysql database?
What is the difference between a database and a table?
Write a query to find duplicate rows in table?
Can u give the example by taking an unnormalized table and make that 1nf and then 25nf, and then 3 nf?
What are the functions used to encrypt and decrypt the data present in mysql?
What is the use of mysql_fetch_array () function in php?
Please can the SQL code below be interpreted IF @xMatchCriteria='MATCH12' BEGIN IF EXISTS (Select * from #InsightData where (EmailAddress=@xDCPEmailAddress ) ) BEGIN SET @xTestMatchCriteria = @xMatchCriteria; SELECT @xCRMCustomerId=CustomerId, @xCRMDcpCustomerId=DcpCustomerId, @xCRMPortalCustomerID=PortalCustomerID,@xCRMDcpID=DcpID, @xCRMCardNumber=CardNumber, @xCRMEmailAddress=EmailAddress, @xCRMfirtLetterFirstName=firtLetterFirstName, @xCRMLastName=Surname,@xCRMAddressLine1=AddressLine1, @xCRMPostCode=PostCode FROM #InsightData where (EmailAddress=@xDCPEmailAddress ) END ELSE BEGIN SET @xTestMatchCriteria='No'+@xMatchCriteria; END END
What is the usage of ENUMs in MySQL?
What is the difference between mysql_fetch_array() and ysql_fetch_object() ?
What is index length in mysql?
How do I view a mysql database?
