Anyone with Mysql and Apache installed on their box?

[Afkamm]

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

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.

[Afkamm]

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.

[Afkamm]

a 500MB database? Eeeeek

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


Marc :O)

[admin]

316M to be exact

[Rodzilla]

MWHAHAHAHA :angry: