Does anyone have any idea where the mariadb database is installed by default on a vps, I need to reinstall the OS and I want to back it up as I installed teamspeak 2 years ago and kind of forgot.
Also is there a way to convert the mariadb to SQLite?
Teamspeak MariaDB
-
- A regular
- Posts: 33
- https://www.youtube.com/channel/UC40BgXanDqOYoVCYFDSTfHA
- Joined: Sat Jul 30, 2016 7:14 pm
Re: Teamspeak MariaDB
If it's like MySQL, its databases would be somewhere in /var, such as /var/lib/mariadb or /var/lib/mysql. The directory used would depend on the OS and its configuration defaults.
This is the TeamSpeak KB article on converting between database types: https://support.teamspeakusa.com/index. ... way-around
This is the TeamSpeak KB article on converting between database types: https://support.teamspeakusa.com/index. ... way-around
-
- A regular
- Posts: 33
- Joined: Sat Jul 30, 2016 7:14 pm
Re: Teamspeak MariaDB
Thank you! I was looking at mariadb's wiki and they said check your my.cnf for the location of the stored data, but there wasn't any info inside the my.cnf.
It's many files, I thought it would be one? Is this the correct format https://ibb.co/dy00kn Do I take the whole folder and then create a new database with the same name and upload this?
It's many files, I thought it would be one? Is this the correct format https://ibb.co/dy00kn Do I take the whole folder and then create a new database with the same name and upload this?
Re: Teamspeak MariaDB
A database is typically contained within a folder corresponding to the database name. Inside that folder are a set of files corresponding to the tables inside the database, with names that match the tables and extensions that correspond to the type of information being stored about the table.
In general, if you are backing up or transferring information between databases, you should export the data to a .sql file and then import it on the other end, instead of trying to copy over the files and folders. You can do this using the mysqldump command-line utility or through a web-based utility such as phpMyAdmin.
In general, if you are backing up or transferring information between databases, you should export the data to a .sql file and then import it on the other end, instead of trying to copy over the files and folders. You can do this using the mysqldump command-line utility or through a web-based utility such as phpMyAdmin.