• Our team is looking to connect with folks who use email services provided by Plesk, or a premium service. If you'd like to be part of the discovery process and share your experiences, we invite you to complete this short screening survey. If your responses match the persona we are looking for, you'll receive a link to schedule a call at your convenience. We look forward to hearing from you!
  • We are looking for U.S.-based freelancer or agency working with SEO or WordPress for a quick 30-min interviews to gather feedback on XOVI, a successful German SEO tool we’re looking to launch in the U.S.
    If you qualify and participate, you’ll receive a $30 Amazon gift card as a thank-you. Please apply here. Thanks for helping shape a better SEO product for agencies!
  • The BIND DNS server has already been deprecated and removed from Plesk for Windows.
    If a Plesk for Windows server is still using BIND, the upgrade to Plesk Obsidian 18.0.70 will be unavailable until the administrator switches the DNS server to Microsoft DNS. We strongly recommend transitioning to Microsoft DNS within the next 6 weeks, before the Plesk 18.0.70 release.
  • The Horde component is removed from Plesk Installer. We recommend switching to another webmail software supported in Plesk.

Question Restore database and change the name

StephM

New Pleskian
Server operating system version
Debian 10
Plesk version and microupdate number
18.0.58
Hi,

Is it possible to change the name of the database in order to restore it without drop the production database ?

thanks
 
Thanks Kaspar,

but i can't rename the database, i need to change the name of the database when i restore it.
 
There is no function (to my knowledge) that does restore a database and renames it too. Those are two separate actions.
 
You could import the backup set to local backups (if not already present in local backups), then descend into the DUMP_D directory defined in psa.conf and get the database dump from there. You can import that dump file into any database you like.

Example: Assume that your local backups are stored in the default /var/lib/psa/dumps. You'd then descend into /var/lib/psa/dumps/clients/<user name>/domains/<domain name>/databases. There you will find a dump file for each database, e.g.
drwxr-xr-x 2 root root 4096 Jan 25 23:35 johndoe_wp_0meuk_1
Although this file is not ending on .sql, it's a normal SQL dump text file that can be imported into any database.
 
I need to restore the January 11 backup without overwriting the database that is in production.
It would be necessary to be able to restore a database by changing the name
 
Have you tried to download and unpack the .tar archive to a temporary directory and descend into the structure as described above to extract the database dump file? You could then import that dump into a different database.
 
Back
Top