![]() Once CyberPanel is installed, select PHPMyAdmin from left-side menu and it will automatically log you into PHPMyAdmin Step 1: Create MySQL Dump from PHPMyAdmin CyberPanel will automatically install PHPMyadmin for you, PHPMyAdmin is graphical user interface to manage MySQL. We will now create database backup using PHPMyAdmin and then restore it via PHPMyAdmin. ![]() sql with actual path to your dump file that you have transferred above. Replace with root or actual user of database, also make sure to replace. Once database is created it is time to restore your dump using the command below mysql -u -p <. Replace with name of database and your database will be created. You can also create database using command line, first login to your MySQL server: mysql -u root -pĬreate database create database If you are using CyberPanel you can create database using this guide. Step 1: Create Databaseīefore doing the restore you need to create database where this dump will be restored. Log into your server via SSH where you have transferred this file. ![]() Second step is to restore the dump file we've just created above. Once MySQL dump is created, you need to move this file to the server where you want to restore it, you can use this guide to move this file: Transfer files over ssh Step 2: MySQL Restore from Dump using Command Line sql will be the resulting file once the dump is done, so give it some friendly name.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |