On a Linux server, the data is stored in /var/lib/mysql or as defined in /etc/my.cnf. You would need root access to get to it. You probably don’t want to do that though, you normally access the database via the mysql command line or a tool such so Phpmyadmin.
WPRanger @ thank you very much for your response. actually, i want to move one my blog to an other hosting. i simply downloaded the blog folder, from old hosting, via ftp and uploaded same folder to new hosting but its not working. some body told me you have to find database file in that folder then attach that file to your new hosting etc. please help.
No, the database data isn’t stored with WordPress. Use a tool like WP Migrate DB to export the database into a transportable file. Then import the file into the new database at your new hosting, using phpmyadmin or similar.
https://wordpress.org/plugins/wp-migrate-db/
WPRanger @ thanks a lot for this free of cost help. Allay may bless you.
