Topic awaiting preservation: MYSql /Access (Page 1 of 1)

Hi all, just wondering - do MYSql databases work the same as say access databases? With my access databases i have a database file in my db directory on my webserver. I created a mysql one for some php forums, it all works fine but i cant seem to find what file the database is stored in. Is it possible stored sub server level (if u know what i mean)

Thanks all

I guess the reason i ask is, i just installed some forums. phpBB forums, one using MS Access Database, and one using MYSql database. Now if i need to move them too another server, it seems simple with the access one because i know where the database is and just simply move it.

Im not sure with the mySQL one tho, anyone have any idea?

thx in advance

H][RO: Ahhhhhhhhhhhhh - in phpMyAdmin you can find an option to dump the database. Grab the contents from there.

___________________
Emps

The Emperor dot org

ta emp...

Im assuming phpMyAdmin is just the adiminstration panel for the phpBB forums. I see an option there to backup database so im guessing that is it ..

The other problem i may have, just for a community gaming site we used to have phpBB forums thats recently went down for some reason, now someone mentioned we might not be able to get the database because its shared mySQL or something??? Im really not sure though, we are trying to contact the guy who was in charge. Is this possibly the case, and if so is it possible just to get one forum from the database? (Ahh.. im not really sure if im asking the right question the right way, hope you understand:P)

It would really be a shame too loose them, 4 years of history would just be lost! *tear*

Nope...phpMyAdmin is a standalone PHP front end for MySQL...lists all of your databases and allows you to do any of the MySQL functions that you would normally do with the command prompt using the graphical front end.

(I think) it can be downloaded from http://www.phpmyadmin.net

oh... well wouldnt the built in "backup database" function in phpbb forums do the same thing?

Quite possibly...

H][RO: Its possible but it may only back up the tables with the phpBB table names. You'd need to check the documentation.

___________________
Emps

The Emperor dot org

I checked it out, is has the options to either do:

->Full Backup
->Structure Only
->Data Only

So looks all good. Interestingly it is not available for the access database, so maybe u can just copy the db file to the new location. But it is available for the mysql one

well, full backup will be structure + data ;-).

I doubt the phpbb would back up anything than it's own tables.
Seriously, download and install a phpmyadmin, and use that.
won't cost you more than 10 minutes to download and setup, and you'll be able to make a complete dump of your database.

i will do for sure sounds good!

i dont have to move the database first just wanted to make sure there was a way i could in the future.