[PHPMyEdit-Discuss] Re: Newbie Question

[lindsay a. <lnz...@sb...>]

Shaun,
default  directory for mysql files is going to depend on the type of 
system you are on.
MySQL database files are binary files, not text files..
they are usually only accessible on the file format level by root.

in your phpMyEdit files, you are going to find some lines that look 
like this
$opts['hn'] = 'localhost';
$opts['un'] = 'theuserid';
$opts['pw'] = 'thepassword';
$opts['db'] = 'tehdatabase';
$opts['tb'] = 'theprimarytable';


these define the access information for the mysql database.

in order for you to migrate the database to another server, you are 
going to need to learn (a little) mysql and some command line
if you want to dump all the data, and have command line access to mysql
then you are going to want to do the following.

log into a shell
run the command:
mysqldump -h localhost -u theruserid -p thedatabase > 
mydatabasebackup.sql.txt

obviously substituting the appropriate login data.
after you hit enter, it will ask you for the password before proceeding.
if all goes well you will have an SQL command script in 
mydatabasebackup.sql.txt
it will be all plain text, so you can see all the data in the database 
and all it's tables.

this will do you little good for phpMyEdit however, except for 
recreating the database in one command on a different server.

you really need to read a MySQL book
or a MySQL/PHP book
most of them are good.