SEO
vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
02-28-2008, 10:30 AM
| |||
| |||
 Re: MySQL file in the same directory with php files Mikhail Kovalev <mikhail_kovalev@mail.ru> wrote in news:870b74db-8fd1-48e3- a353-67f7ab270197@w34g2000hsg.googlegroups.com: > Is it possible without changing default directory in config files? > This is for an offline project. > > Thanks. > What exactly is a MySQL file? I'm not sure it's clear what you want to do...      |
|
02-28-2008, 10:30 AM
| |||
| |||
| Re: MySQL file in the same directory with php files On 6 Des, 19:40, Good Man <he...@letsgo.com> wrote: > Mikhail Kovalev <mikhail_kova...@mail.ru> wrote in news:870b74db-8fd1-48e3- > a353-67f7ab270...@w34g2000hsg.googlegroups.com: > > > Is it possible without changing default directory in config files? > > This is for an offline project. > > > Thanks. > > What exactly is a MySQL file? I'm not sure it's clear what you want to > do... I want everything contained in one directory, scripts & the database, to be able to move it to another machine as one directory, or at least share the database as a file. |
|
02-28-2008, 10:30 AM
| |||
| |||
| Re: MySQL file in the same directory with php files Mikhail Kovalev <mikhail_kovalev@mail.ru> wrote in news:b9f8a8b6-e311-4ba7-83f6-4507bb0ba233@s8g2000prg.googlegroups.com: > On 6 Des, 19:40, Good Man <he...@letsgo.com> wrote: >> Mikhail Kovalev <mikhail_kova...@mail.ru> wrote in >> news:870b74db-8fd1-48e3- >> a353-67f7ab270...@w34g2000hsg.googlegroups.com: >> >> > Is it possible without changing default directory in config files? >> > This is for an offline project. >> >> > Thanks. >> >> What exactly is a MySQL file? I'm not sure it's clear what you want >> to do... > > I want everything contained in one directory, scripts & the database, > to be able to move it to another machine as one directory, or at least > share the database as a file. > MySQL is database software; if you're going to move things between machines, you need each machine to have MySQL installed. Not only that, but you'll have to dump and restore the database contents each time. Maybe you should set up MySQL on a server that will always be online... then your scripts can just connect to the server and use/share the data. |
|
02-28-2008, 10:30 AM
| |||
| |||
| Re: MySQL file in the same directory with php files On 6 Des, 20:05, Good Man <he...@letsgo.com> wrote: > Mikhail Kovalev <mikhail_kova...@mail.ru> wrote innews:b9f8a8b6-e311-4ba7-83f6-4507bb0ba233@s8g2000prg.googlegroups.com: > > > > > On 6 Des, 19:40, Good Man <he...@letsgo.com> wrote: > >> Mikhail Kovalev <mikhail_kova...@mail.ru> wrote in > >> news:870b74db-8fd1-48e3- > >> a353-67f7ab270...@w34g2000hsg.googlegroups.com: > > >> > Is it possible without changing default directory in config files? > >> > This is for an offline project. > > >> > Thanks. > > >> What exactly is a MySQL file? I'm not sure it's clear what you want > >> to do... > > > I want everything contained in one directory, scripts & the database, > > to be able to move it to another machine as one directory, or at least > > share the database as a file. > > MySQL is database software; if you're going to move things between > machines, you need each machine to have MySQL installed. Not only that, > but you'll have to dump and restore the database contents each time. > > Maybe you should set up MySQL on a server that will always be online... > then your scripts can just connect to the server and use/share the data. Software is not a problem on the machines and an online server I think will not be the best option. I need the table in a separate file... sort of like a xml file. Is there other database software which does it? |
|
02-28-2008, 10:30 AM
| |||
| |||
| Re: MySQL file in the same directory with php files On Thu, 06 Dec 2007 20:13:25 +0100, Mikhail Kovalev <mikhail_kovalev@mail.ru> wrote: > On 6 Des, 20:05, Good Man <he...@letsgo.com> wrote: >> Mikhail Kovalev <mikhail_kova...@mail.ru> wrote >> innews:b9f8a8b6-e311-4ba7-83f6-4507bb0ba233@s8g2000prg.googlegroups.com: >> > On 6 Des, 19:40, Good Man <he...@letsgo.com> wrote: >> >> Mikhail Kovalev <mikhail_kova...@mail.ru> wrote in >> >> news:870b74db-8fd1-48e3- >> >> a353-67f7ab270...@w34g2000hsg.googlegroups.com: >> >> >> > Is it possible without changing default directory in config files? >> >> > This is for an offline project. >> >> >> > Thanks. >> >> >> What exactly is a MySQL file? I'm not sure it's clear what you want >> >> to do... >> >> > I want everything contained in one directory, scripts & the database, >> > to be able to move it to another machine as one directory, or at least >> > share the database as a file. >> >> MySQL is database software; if you're going to move things between >> machines, you need each machine to have MySQL installed. Not only that, >> but you'll have to dump and restore the database contents each time. >> >> Maybe you should set up MySQL on a server that will always be online... >> then your scripts can just connect to the server and use/share the data. > > Software is not a problem on the machines and an online server I think > will not be the best option. > I need the table in a separate file... sort of like a xml file. Is > there other database software which does it? If that's a requirement for your project, why not use SQLite? Granted, performance is not even close the that of MySQL, but it is highly portable. Sharing files/transferring raw MySQL database files is just a crash waiting to happen... -- Rik Wasmus |
|
02-28-2008, 10:30 AM
| |||
| |||
| Re: MySQL file in the same directory with php files == Quote from Mikhail Kovalev (mikhail_kovalev@mail.ru)'s article > On 6 Des, 20:05, Good Man <he...@letsgo.com> wrote: > > Mikhail Kovalev <mikhail_kova...@mail.ru> wrote innews:b9f8a8b6-e311-4ba7-83f6-4507bb0ba233@s8g2000prg.googlegroups.com: > > > > > > > > > On 6 Des, 19:40, Good Man <he...@letsgo.com> wrote: > > >> Mikhail Kovalev <mikhail_kova...@mail.ru> wrote in > > >> news:870b74db-8fd1-48e3- > > >> a353-67f7ab270...@w34g2000hsg.googlegroups.com: > > > > >> > Is it possible without changing default directory in config files? > > >> > This is for an offline project. > > > > >> > Thanks. > > > > >> What exactly is a MySQL file? I'm not sure it's clear what you want > > >> to do... > > > > > I want everything contained in one directory, scripts & the database, > > > to be able to move it to another machine as one directory, or at least > > > share the database as a file. > > > > MySQL is database software; if you're going to move things between > > machines, you need each machine to have MySQL installed. Not only that, > > but you'll have to dump and restore the database contents each time. > > > > Maybe you should set up MySQL on a server that will always be online... > > then your scripts can just connect to the server and use/share the data. > Software is not a problem on the machines and an online server I think > will not be the best option. > I need the table in a separate file... sort of like a xml file. Is > there other database software which does it? yes, it is possible to have separate table files. you can achieve this with setting this variable in your my.conf: innodb_file_per_table then definte an innodb_date_home_dir and a couple of other variables and you're set to go. you can find out all the details on mysql.com's website though. -- POST BY: lark with PHP News Reader ;o) |
|
02-28-2008, 10:30 AM
| ||||
| ||||
| Re: MySQL file in the same directory with php files lark <hamzee@sbcglobal.net> wrote in news:XsZ5j.30707$Pv2.17152@newssvr23.news.prodigy. net: > yes, it is possible to have separate table files. you can achieve this > with setting this variable in your my.conf: > innodb_file_per_table > then definte an innodb_date_home_dir and a couple of other variables > and you're set to go. > > you can find out all the details on mysql.com's website though. Yes, you can have seperate table files... but sort of irrelevant to this problem. Just because innodb tables are in those files doesn't mean you can access them without MySQL in any way. More importantly, should you ever move those files between servers? Not unless you want to introduce a lot of problems - it's incredibly dangerous, unreliable and useless. The suggestion of SQLite was a good one, but if you're moving data between databases and not using mysqldump, then you are simply asking for a whole lotta hurt in your world. |
Linear Mode
