Hello Guys,
I'm troubling with one problem, actually I want to create a backup of
MYSQL database. So, could you tell me how to perform this task.
Please resolve my problem as soon as possible.
Technology
Web App Development
Mobile App Development
Windows App Development
Database Development
UI/UX Development
Cloud Development
SEO
Digital Marketing
Guest Posting
Content Writing
Artificial Intelligence
Data Science
ERP Development
CRM Development
CMS Development
LMS Development
Business Listing
Blockchain Technology
Startup Promotion
AI Tools Integration
It is not big issue, to resolve this problem you can use following query...
Query: "SELECT * INTO OUTFILE '$backupFile' FROM $tableName";
Where,
$backupFile -> is backup file name with path.
$tableName -> is that table for which you create backup.
I hope it might be helpful for you.