Individum

I apologize in advance if this question may sound utterly stupid. I'm using a lot of PHP on my sites but I hardly know the basics of it...

Thing is, I have only one MySQL db (Learner package. I'll probably upgrade it when the year is over, but I still got 9 months to go). I use this db on all of my sites and subdomain, I got *quite* a few. I use certain scripts that just install new tables on the same single db. I also heard that this is actually a more efficient way to use MySQL db, instead of creating a new db each time just for a couple of tables.

SO, my question is: Can the Fantastico installations use the same existing db, or will they run over it? I'm really curious about Fantastico but I'm afraid to try anything, because god forbid I lose my current db, with all its data for all of my sites.

Thanks in advance for any help on this

__________________
Domain: individum.com
Server: Sea

patrickb

I don't think the Fantastico installations can use the same DB across the board. Most of the auto installs for those scripts make their very own little DB and use it. You can however upgrade your account now if you are ready. Surpass will refund the remainder of your current balance, and then you startup a new plan and begin paying on it.

__________________
Patrick

Warnings: The program(s) might crash unexpectedly or behave otherwise strangely. (But of course, so do many commercial programs on Windows.) --www.gimp.org

snide

I,
while you're thinking about it, make sure that you are making fresh backups of your db's, please.

__________________
Dime13 | Pass17

Individum

Thanks for the reply.
What do you mean by "make sure that you are making fresh backups of your db's"??? On a regular basis? Or regarding my question?
*runs to make a backup*

Anyway, as I said, I still have 9 months in my learner's package, which is exactly half the price of the most basic package that currently exists, so I'd rather wait untill the year is over, rather than upgrade my package now and pay twice as much just so that I could play a little with my Fantastico...

__________________
Domain: individum.com
Server: Sea

SLBlay

Ok, I'm learning about MySQL databases - Working with a Fantastico osCommerce install.

It configures (creates?) a file named data.sql in "/home/account-name/public_html/top-level directory".
Is that the MySQL database file?

However, if instead I had created a MySQL database using "cPanel-MySQL Databases", there appears to be no identifiable database file (*.sql) in any of my "/home/<account-name> folders"! Where did it put my database? How can I force it to be in a local file in my folders?

So, I have two questions:
1. Where is my MySQL database located in the second example?
2. If 1 were to install osCommerce myself (manually), how would it know where to find the correct database to connect to?

Any "server-side MySQL gurus" out there who can explain, please? :frust:

__________________
- Steve. Server: dime29. Domain Name: cosmicgeeks.com

patrickb

Usually the mysql databases are under /usr/local/mysql/data/ but not always. That data.sql file you see is not the actual database file. It is just an exported version of one. You can't get the database in your home folder.

As for installing osCommerce manually, it will find the database just fine. It actually makes a connection through a port to mysql, and then looks up the DB name it was configured to use.

__________________
Patrick

Warnings: The program(s) might crash unexpectedly or behave otherwise strangely. (But of course, so do many commercial programs on Windows.) --www.gimp.org