Anyone with Mysql and Apache installed on their box?

Just install apache, mysql, php and perl on my winME box so I can play with my http://www.phpbb.com forum board

Now the mysql database that's been created is seperated into a lot of files, whereas the backup of my online forum mysql database is just one file with no extension. Using phpMyAdmin I can output the offline forum database as one file with the extension .sql.

Examing these two files I can see small changes, but would it still be ok to upload this file if I remove the .sql extension?

ie. Configure everything offline, then upload.

Suppose I could try it, but I just thought I'd ask to see if anyone does this. :-)


Marc :O)

[admin]

the many files that you get in the mysql data directory translate into all of the tables that are used. The .sql file is actually a list of commands that is essentially a dump of the database. This sql file is all the commands that you would use to instruct mysql to rebuild your database and fill all those tables with data.

Is that how it is on the Mysql server? The database is numerous files for each table which are then dumped into one when a backup is requested?


What time are the backups done at, or are they done on the fly when you click the link from within cPanel? :-)

Cheers

Marc :O)

[admin]

On the fly when you click the button

Also, it is not just all the files dumped into one. It is actually a pretty cpu intensive operation to convert from a database to a dump and back again.

One of our users has a 500M database and the server cpu has to work really hard to import that data...it can take a very long time to import it.

a 500MB database? Eeeeek

It'll probably zip down to about 300-350 though for downloading


Marc :O)

[admin]

316M to be exact

MWHAHAHAHA