![]() This action will take some time (depending on how large the database is). sql backup file you downloaded from the export.įigure E Restoring a MySQL database using the phpMyAdmin import tool. In this new window ( Figure E), click the Browse button and then locate the. ![]() Once the database has been created, select it from the left navigation and click the Import tab. Type the name of the new database and click Create (Figure D).įigure D Recreating the deleted database. Go to the main phpMyAdmin window and go to the Databases tab. Once you’ve done that, you then need to create a new database with the same name. Where NAME is the name of the database to be deleted. To do that, click on the SQL tab and, in the query pane ( Figure D - the text area above the Submit Query button) type: Should something go wrong with your database (let’s hope it never does), you can restore it from your latest backup but it’s not quite as straightforward as is the backup.įirst off, you have to delete the failed backup From phpMyAdmin. ![]() I’d suggest getting in the habit of doing this daily. Because of this, you must manually back them up. One thing to keep in mind is that phpMyAdmin can’t regularly back up your databases. Save the file and the backup is complete. In the next window ( Figure C), make sure to select Quick, and SQL format.įigure C You can ignore the export template window for basic backups.Ĭlick Go and you’ll be prompted to save the. Once you’ve selected the database, go to the main pane and select the Export tab ( Figure B).įigure B The export tab is where the backup process is found. Log in to phpMyAdmin and select the database to be backed up from the left navigation ( Figure A).įigure A I’m going to back up my nextcloud database. The first thing we’ll do is back up the database. How to back up a database with phpMyAdmin With those things at the ready, let’s back up and restore that data. A user with full access to the databases (such as the phpmyadmin user).You’ll need three things to make this happen: SEE: 40+ open source and Linux terms you need to know (TechRepublic Premium) What you’ll need That, my friends, is exactly what I’m going to show you today.Īfter you read how easy this is, you might never go back to the terminal for this task. But there might be times when you want to work with a bit more efficiency, such as by way of a web-based GUI like phpMyAdmin. This is most definitely a technique you should know. I’ve already walked you through the process of doing so from the command line. To avoid that, you need to back up those databases. How to Create and Use a Docker Secret From a File (+Video)ĬISA Aims For More Robust Open Source Software Security for Government and Critical Infrastructureīest of Open Source Summit Europe 2023: The State of the Open Nation How to Set Temporary Environment Variables in Linux (+Video Tutorial) That would cost you money, an outcome you certainly do not want. Should one of those databases fail, your workflow could come to a standstill. Many of your business processes depend on databases.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |