Home Button  Buy Button 

Topic:   Backup Database

By: StanPosted on: Mar 29 2022 at 09:52:00 AM
According to the "online user manual", there is a menu under "Tools" to backup the database. This menu item does not exist in my installation. I only have a "Setup/Tools" option. Within "Setup/Tools" there is not a "Database Utilities" option. I am using MariaDB, and trying to do a backup.

By: GuestPosted on: Mar 30 2022 at 04:16:07 AM
There are some restrictions when using the 'Pro' version with MSSQL, MySQL or MariaDB which may require your server administrator to complete the task. when using one of the afore mentioned servers then the MiniMRP user account shouldn't really have credentials to backup or restore an SQL Server/MySQL/MariaDB database so the backup/restore button is not available in the MiniMRP program.

Best thing is to have your server administrator use the tools provided by Microsoft for SQL Server or MySQL to back up databases on the server.

On the other hand. The person who installed MiniMRP and created the database in the server will know where to find the MiniMRP DBTools program. Using MiniMRP's separate DBTools.exe program you can backup and restore the minimrp database.

By: StanPosted on: Mar 30 2022 at 06:18:29 AM
I have tried using DBTools for the backup. Both from the server and from a client PC. In both cases, I can connect to the server successfully. When I try to backup, I get the error "Could not connect to a database named 'minimrp_db5'. Check the spelling/database and try again. "minimrp_db5" is the correct name for our database. I can provide screenshots if that helps.

By: SupportPosted on: Mar 30 2022 at 08:35:37 AM
Was it you who set up the server? Or maybe a colleague did it?

When you originally created the database in the server you must have used our DBtools to do that. So at the time the database was originally created in the server the credentials to do that must have been correct at that time. What's changed?

Do you also use phpMyAdmin to administer the server?

Could you provide three screenshots? (So I can see what you're doing and compare)

Screenshot of the database from within phpMyAdmin (if possible)
Screenshot of the server connection window in DBTools and the error message when you try to connect
Screenshot of the database setup within MiniMRP

By: StanPosted on: Mar 31 2022 at 07:04:01 AM
Requested info emailed

By: SupportPosted on: Apr 1 2022 at 03:59:10 AM
Thank you for the screenshots Stan. We're looking at that right now.

I'll also take a look at that "other" tool that you mentioned. It does look like a good tool and will probably be twice as fast as our own tool.

The reason our tool is slower is that it's not actually making a standard backup file. It's making a generic Migration file (allowing our database to be migrated between any of the supported server types). Making such a migration file just takes longer.

ANyway. I'll look into your problem but, in the meantime, just keep using that other tool which is probably better anyway.

I'll come back to you by email and also post here in case anyone else is having the same problem.

By: SupportPosted on: Apr 1 2022 at 07:37:54 AM
Stan. I've looked at your screenshots and it looks like you're doing it correctly. But...

I just can not reproduce the error. I thought maybe it could be some case-sensitive thing with the database name but DBTools works round that. So I'm stuck. It really looks like the database doesn't exist on the server.

On the other hand I did look at that other backup/restore tool you mentioned and that looks ok. So just keep using that.

Reply - add a comment to this topic.

You may enter letters, numbers and standard punctuation only. HTML and other scripts/tags will be rejected.

Topic:- Backup Database

Enter the numbers.

Your name here is optional