Menu
▾
▴
phpmyedit-discuss
|
From: cryst <cr...@go...> - 2005-01-21 15:04:06
|
Shaun, What you need to do is look at your page that is being accessed by the website. It will have the extension php, which contains php code. In there near the top you will see // MySQL host name, user name, password, database, and table $opts['hn'] = 'localhost'; $opts['un'] = 'Your Sites name'; $opts['pw'] = 'Your database password'; $opts['db'] = 'Your database Name'; $opts['tb'] = 'The table this page is accessing'; I believe that is the info you are asking for. If you have never used mysql before, Do yourself a favor and do some tutorials available on the web. If you have never used php before, good luck. :) Chris Bruner ----- Original Message ----- From: <php...@li...> To: <php...@li...> Sent: Thursday, January 20, 2005 11:27 PM Subject: Phpmyedit-discuss digest, Vol 1 #84 - 3 msgs > Send Phpmyedit-discuss mailing list submissions to > php...@li... > > To subscribe or unsubscribe via the World Wide Web, visit > https://lists.sourceforge.net/lists/listinfo/phpmyedit-discuss > or, via email, send a message with subject or body 'help' to > php...@li... > > You can reach the person managing the list at > php...@li... > > When replying, please edit your Subject line so it is more specific > than "Re: Contents of Phpmyedit-discuss digest..." > > > Today's Topics: > > 1. Newbie Question (Shaun MacPherson) > 2. Re: Newbie Question (al...@ow...) > 3. Re: Newbie Question (Shaun MacPherson) > > --__--__-- > > Message: 1 > Date: Thu, 20 Jan 2005 10:52:52 -0500 > From: Shaun MacPherson <sma...@gm...> > Reply-To: Shaun MacPherson <sma...@gm...> > To: php...@li... > Subject: [PHPMyEdit-Discuss] Newbie Question > > Hello! > > I inhereted the task of maintaining a website and I noticed that they > use PhpMyEdit which is working good except for one small problem with > their setup. I cannot find where the database file is, or what it is > called. > > I made a backup/copy of the website and did a search for elements in > the database (e.g. a person's name) but could not find the database > file. Could you tell me A) the default filename of the MySQL database > that contains the table information and B) where it is stored? I also > noticed that there are 2 directories I do not have access to (CONF, > PD) in the root directory, perhaps they are in there? > > Thanks! > > Shaun > > > --__--__-- > > Message: 2 > Date: Thu, 20 Jan 2005 16:48:38 -0000 (GMT) > Subject: Re: [PHPMyEdit-Discuss] Newbie Question > From: al...@ow... > To: "Shaun MacPherson" <sma...@gm...> > Cc: php...@li... > Reply-To: al...@ow... > > Hello Shaun, > > I am afraid you need to pick up a book about MySQL or visit one of the > many sites with the MySQL documentation. MySQL is a proper relational > database and you seem to think it is something like Access which is little > more than a file format. > > I doubt that learning about MySQL is the job of this list. > > You need to learn about sql, how to use the command line program, how to > do a backup, how to do a restore, and so on. phpMyEdit will help you with > some of this but you ought to know how to do it without phpMyEdit too. > > Goodluck > > Alex > > Shaun MacPherson said: >> Hello! >> >> I inhereted the task of maintaining a website and I noticed that they >> use PhpMyEdit which is working good except for one small problem with >> their setup. I cannot find where the database file is, or what it is >> called. >> >> I made a backup/copy of the website and did a search for elements in >> the database (e.g. a person's name) but could not find the database >> file. Could you tell me A) the default filename of the MySQL database >> that contains the table information and B) where it is stored? I also >> noticed that there are 2 directories I do not have access to (CONF, >> PD) in the root directory, perhaps they are in there? >> >> Thanks! >> >> Shaun >> >> >> ------------------------------------------------------- >> 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 >> >> > > > -- > > Alex McLintock > Openweb Analysts Ltd > Software for Complex Websites > > > --__--__-- > > Message: 3 > Date: Thu, 20 Jan 2005 11:52:20 -0500 > From: Shaun MacPherson <sma...@gm...> > Reply-To: Shaun MacPherson <sma...@gm...> > To: al...@ow... > Subject: Re: [PHPMyEdit-Discuss] Newbie Question > Cc: php...@li... > > Thanks for your reply :D. > > I was probably was unclear in what I was requesting - Clearly database > data are stored in a number of files on the webserver's hard drive. I > want to know what the default directory is, if any, and what the > default extension is for MySQL files, if any. > > Our 'online' website has a database of phone #'s etc > (http://chamber.parrysound.com/search.php if anyone is interested in > our site :P ), but as I said the mirror I made via FTP on my hard > drive lacks the database. > > Thanks for your help, > > Shaun > > > > On Thu, 20 Jan 2005 16:48:38 -0000 (GMT), al...@ow... > <al...@ow...> wrote: >> Hello Shaun, >> >> I am afraid you need to pick up a book about MySQL or visit one of the >> many sites with the MySQL documentation. MySQL is a proper relational >> database and you seem to think it is something like Access which is >> little >> more than a file format. >> >> I doubt that learning about MySQL is the job of this list. >> >> You need to learn about sql, how to use the command line program, how to >> do a backup, how to do a restore, and so on. phpMyEdit will help you with >> some of this but you ought to know how to do it without phpMyEdit too. >> >> Goodluck >> >> Alex >> >> Shaun MacPherson said: >> > Hello! >> > >> > I inhereted the task of maintaining a website and I noticed that they >> > use PhpMyEdit which is working good except for one small problem with >> > their setup. I cannot find where the database file is, or what it is >> > called. >> > >> > I made a backup/copy of the website and did a search for elements in >> > the database (e.g. a person's name) but could not find the database >> > file. Could you tell me A) the default filename of the MySQL database >> > that contains the table information and B) where it is stored? I also >> > noticed that there are 2 directories I do not have access to (CONF, >> > PD) in the root directory, perhaps they are in there? >> > >> > Thanks! >> > >> > Shaun >> > >> > >> > ------------------------------------------------------- >> > 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 >> > >> > >> >> -- >> >> Alex McLintock >> Openweb Analysts Ltd >> Software for Complex Websites >> > > > > --__--__-- > > _______________________________________________ > Phpmyedit-discuss mailing list > Php...@li... > https://lists.sourceforge.net/lists/listinfo/phpmyedit-discuss > > > End of Phpmyedit-discuss Digest > |
|
From: lindsay a. <lnz...@sb...> - 2005-01-21 16:43:55
|
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. |
|
From: Shaun M. <sma...@gm...> - 2005-01-21 21:46:17
|
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 > |
×
Want the latest updates on software, tech news, and AI?
Get latest updates about software, tech news, and AI from SourceForge directly in your inbox once a month.
Thanks for helping keep SourceForge clean.
X