This is a question for Wordpress experts. I have a regular Wordpress blog hosted on Hostgator and I can't find where the database is. I've been looking all over and I can't find it. I'm not talking about the Wordpress .php or .css files. In What specific DIRECTORY can I find the Wordpress DATABASE file(s)? Isn't it a file? What's the filename?
You might now have access to that if you are on a shared server. Usually you will find them in the root folder under var/lib/mysql/ Under that directory every database will have a directory and every table within the db will have a set of files. If you want to make changes tho, you are better off logging into phpmyadmin. Hope this helps
if you are using a Linux hosting then you need to use PHPmyadmin to get database file/backup for backup you can use some wordpress plugin
Can find that file. This is a working WP website. Do you know where the WP database files and directory is at?
which hosting you are using? ask their support, they will guide you it seems that you are new to the hosting world!
Why do you need access to the database files? They aren't human readable and you would need to use mysql or phpmyadmin to read them. Further, if you use InnoDB for any of your WordPress tables and you did manage to get your files that are located in /var/lib/mysql (you do not have access to this directory so don't try to access it via FTP) you would be missing content as it's stored in the innodb shared table space. From within cPanel you can create human-readable sql backups.
If you have access to cPanel, which is normal with hostgator, from the main cPanel page find phpMyAdmin and click on it. Then find the database which correspnds to your wordpress site (to find: open wp-config.php in filemanager and get the db number/name) select the db, then click export, you will be able to download it in a .zip folder.