Transferring MySQL database files and Accessing Locally

Hi Everyone. This may be a stupidly simple question. I am trying to download a MySQL database from a server but can't seem to find the files anywhere in the server directory. Does anyone know where these files are typically located, and also what format they are?

I've also tried installing phpmyadmin to my server (accuwebhosting.com) and because they are running php 4.4.3, it will not execute. Any alternative options?

I'm trying to store these files locally and manage them with phpmyadmin. I'd also like to eventually export the data to CSV.

Thanks!
Mike

 

Use a free software like navicat lite from your desktop. It has a import feature which u can use to import the db. There are other free softwares but this one is one i have tested and which i can say for sure works

 

Make sure you remember the password for the DB and your safe.

 

Does that mean that with navicat lite you can download the DB and modify it locally? Can you then upload it again with the changes?

 

yes that is possible. well atleast with mysql you can. But remember after downloading you need mysql running on your local server. You can then upload it again

 

Thanks for the responses. So navicat will allow you to log in to an SQL server hosted online? I have an IP adress for a location, will that work?

I got an older version of phpmyadmin running on my server (2.11). When i initally log in to it, what usernam/pass is it looking for? The username/pass for my control panel or something else?

 

yes you can use navicat to access a database online but you need to Allow external access of the database.

The username, password are the username and password of the mysql user. The privilages apply.