Re: [PHPMyEdit-Discuss] Re: Newbie Question

[Shaun M. <sma...@gm...>]

Hi :D,

My goodness, you are right - I saw exactly what you described
(localhost, theuserid) etc.

I think I know enough about MySQL now to know that I need a lot more
information, and that it seems to be a server model rather than
specific files.  I am going to go buy a book like you said, thanks for
the information and putting up with me :)).

Thanks for helping me Alex and Lindsay, and thanks to the people for
making PHPMyEdit free(dom) software!

Shaun



On Fri, 21 Jan 2005 08:43:51 -0800, lindsay adams
<lnz...@sb...> wrote:
> 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.
> 
> -------------------------------------------------------
> This SF.Net email is sponsored by: IntelliVIEW -- Interactive Reporting
> Tool for open source databases. Create drag-&-drop reports. Save time
> by over 75%! Publish reports on the web. Export to DOC, XLS, RTF, etc.
> Download a FREE copy at http://www.intelliview.com/go/osdn_nl
> _______________________________________________
> Phpmyedit-discuss mailing list
> Php...@li...
> https://lists.sourceforge.net/lists/listinfo/phpmyedit-discuss
>