Please help. What should I choose to backup a .sql file from phpmyadmin? I was under the impression that it was (Contents of server’s MariaDB databases) but I’m wrong.
| Webmin version | 2.202 | Usermin version | 2.102 |
|---|---|---|---|
| Virtualmin version | 7.20.2 | ||
| Ubuntu Linux 22.04.5 |
are you sure? what was missing?
Yes, I’m sure the 2 files are different. Look at the first image, the backup from virtualmin for (Contents of server’s MariaDB databases) and the second, the backup from phpmyadmin.
So the diff is the “DROP TABLE IF EXISTS” which in the case of phpMyAdmin must be included in the Options Tab. Is that the only one or do I need 
The option I (Contents of server’s MariaDB databases) have set only backups up to the MariaDB dump file. I’m waiting for those responsible to answer how what I’m asking can be done.
I am sure that when @staff see this they will attempt to resolve it.
Though peraps a little clearer in what the specific request actually is might help?
as I’m still confused about what is wrong with the current backup.
(which I have used on several occasions to successfully transfer complete VS and individual DB)
You’re not wrong—the MariaDB dump will be included if backed up based on the options selected in your config.
Alternatively, you can make a direct dump using the “Servers ⇾ MariaDB Database Server: Edit Database / Backup Database” page.
Thank you! Ιlia…
I hadn’t seen this setting. Why do I select the folder I want for the backup and get an error? I go to virtualmin - edit databases - manage in the database I want. - backup database I save and get an error? What am I doing wrong?
Click the “Backup Now” button instead, and it’s probably best to use the “Download in browser” option. If you want to save it to the server, place it somewhere under the /root directory—don’t save it under /home.
I made a folder in /root/backup sql but I get the same error again…
You should click the “Backup Now” button at the bottom of the page, not “Save”.
Name it something else, like /root/backup-db.sql file.
So I need to create a backup-db.sql file?? Not a folder?
You don’t need to create anything—the module will handle it for you!
Sorry, I don’t understand what exactly is the Path on server that I need to write?
Try this one:
/root/backup-db.sql
This works!!! But I have a problem with the characters, I don’t have Greek. I have these settings.
from phpmyadmin the sql.
Keep charset set to “Default”.
Ok with the characters.
But I don’t understand why the file is not the same as the one from phpmyadmin??
