MySQL/PHP

Twilkitri · Post by **Twilkitri** » Tue Sep 23, 2003 9:34 am

For once, I'm not asking for help :/
Unless you have a very broad definition of the word...

OK, I'm around halfway through rewriting the STS page into PHP/MySQL, and I was wondering...

a) How do I remotely get a table into the tgb MySQL db...?
b) What do I use as the hostname? localhost, since PHP is server-side, or something different?

Thanks...

Post by **beyonder** » Tue Sep 23, 2003 9:54 am

first you need a db account, then you need a db then you can put tables in it using the mysql.exe that comes with the windows distro of the sql server...you need to read the command line options to get it to work, localhost will work for hostname, thegreatbeyond.net will too, anything else will need to be an IP address(the server doesnt have a DNS lookup, but recognizes that tgb.net is itself) so if you have your own database server...

Twilkitri · Post by **Twilkitri** » Tue Sep 23, 2003 10:08 am

OK, how would I go about getting an account...?

Post by **beyonder** » Tue Sep 23, 2003 11:39 am

you find the person who owns the site(me) and give them a password and a username, and a database name

Twilkitri · Post by **Twilkitri** » Mon Sep 29, 2003 9:59 pm

I can't seem to connect, through the DOS MySQL binary or NaviCat.

I don't know whether I'm doing something wrong, or whether you haven't made the user or not yet...

http://www.thegreatbeyond.net/DarkTwilk ... sqlimport/
In any case, can you import my current files into the database for me so I can test that they work with my test pages? If I can't access it with the binary but I can over the net, that's okay because I can make a page to let me update...

I've migrated around half my pages to use PHP/MySQL now, I can't update until I get it working... they work on my computer/network...

Post by **beyonder** » Tue Sep 30, 2003 2:01 pm

well you havent given me an account name or password or a name for the db.....

Twilkitri · Post by **Twilkitri** » Thu Oct 02, 2003 5:03 am

I emailed you through the boards :O
I even sent a copy to myself...

Fine, I'll do it again.