Closed Thread Icon

Topic awaiting preservation: MYSql /Access Pages that link to <a href="https://ozoneasylum.com/backlink?for=12952" title="Pages that link to Topic awaiting preservation: MYSql /Access" rel="nofollow" >Topic awaiting preservation: MYSql /Access\

 
Author Thread
H][RO
Bipolar (III) Inmate

From: Australia
Insane since: Oct 2002

posted posted 10-27-2003 01:29

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

H][RO
Bipolar (III) Inmate

From: Australia
Insane since: Oct 2002

posted posted 10-27-2003 02:49

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

Emperor
Maniac (V) Mad Scientist with Finglongers

From: Cell 53, East Wing
Insane since: Jul 2001

posted posted 10-27-2003 02:52

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

___________________
Emps

The Emperor dot org

H][RO
Bipolar (III) Inmate

From: Australia
Insane since: Oct 2002

posted posted 10-27-2003 06:06

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*

Skaarjj
Maniac (V) Mad Scientist

From: :morF
Insane since: May 2000

posted posted 10-27-2003 08:27

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

H][RO
Bipolar (III) Inmate

From: Australia
Insane since: Oct 2002

posted posted 10-27-2003 08:53

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

Skaarjj
Maniac (V) Mad Scientist

From: :morF
Insane since: May 2000

posted posted 10-27-2003 09:04

Quite possibly...

Emperor
Maniac (V) Mad Scientist with Finglongers

From: Cell 53, East Wing
Insane since: Jul 2001

posted posted 10-27-2003 13:29

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

H][RO
Bipolar (III) Inmate

From: Australia
Insane since: Oct 2002

posted posted 10-28-2003 01:41

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

Tyberius Prime
Paranoid (IV) Mad Scientist with Finglongers

From: Germany
Insane since: Sep 2001

posted posted 10-28-2003 09:27

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.

H][RO
Bipolar (III) Inmate

From: Australia
Insane since: Oct 2002

posted posted 10-28-2003 10:21

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.

« BackwardsOnwards »

Show Forum Drop Down Menu