mySQL databases and guestbook, plz

[Lilymon]

hello everyone,
i've recently registered with HG and im a total newb when it comes to web-mastering and managing accounts .. so far, i've been digging this forum and the knowledgebase for answers and i've found some answers to questions i had but im still facing this one tiny problem i hope someone be able to help me with it or guide me to where i can find my answers please ;__;

firstly, how exactly do i change nameservers ? or do i have to do it in the first place ? my domain is lillymon.net .. how do i know if the dns is already propagated or not ? do i have to change it in the first place ?

secondly, im trying to set up my guestbook which uses mysql database .. i read the FAQ on how to setup one and followed the exacst instructions but i still get the "can not access mysql database" error when i try to install the guestbook. what went wrong ?
and why do i see this "no previliges" message ?

http://img.photobucket.com/albums/v4...ymon/mysql.jpg

any help will be highly appreciated .. please, its been two weeks since i registered and i still couldn't figure out much ;;__;;
excuse my ignorance but im totally new to this ..
thank you heaps in advance

[quietFinn]

Originally Posted by Lilymon

hello everyone,
i've recently registered with HG and im a total newb when it comes to web-mastering and managing accounts .. so far, i've been digging this forum and the knowledgebase for answers and i've found some answers to questions i had but im still facing this one tiny problem i hope someone be able to help me with it or guide me to where i can find my answers please ;__;

firstly, how exactly do i change nameservers ? or do i have to do it in the first place ? my domain is lillymon.net .. how do i know if the dns is already propagated or not ? do i have to change it in the first place ?

The nameservers seem to be ok, they are:

Name Servers:
ns339.hostgator.com
ns340.hostgator.com

Originally Posted by Lilymon

secondly, im trying to set up my guestbook which uses mysql database .. i read the FAQ on how to setup one and followed the exacst instructions but i still get the "can not access mysql database" error when i try to install the guestbook. what went wrong ?
and why do i see this "no previliges" message ?

http://img.photobucket.com/albums/v4...ymon/mysql.jpg

any help will be highly appreciated .. please, its been two weeks since i registered and i still couldn't figure out much ;;__;;

You don't create the databases in phpMyAdmin, you do it in cPanel, in "Site Management Tools->MySQL Databases".

[Lilymon]

thank you quietfinn for the help ^^ .. i somehow figured out the database problem and have successfully installed the guestbook . .everything went smoothly ..

You don't create the databases in phpMyAdmin, you do it in cPanel, in "Site Management Tools->MySQL Databases".

the reason why i entered phpMyAdmin is because i wanted to import the guestbook database from my old server.
i still need to figure out how is that done ..

thank you very much once again for your help .. i'll start searching topics for database import/export before asking again

[slapshotw]

Originally Posted by Lilymon

thank you very much once again for your help .. i'll start searching topics for database import/export before asking again

This is probably the easiest part. If you know your way around phpmyadmin, go to the database or table you want, and click export on top. Make sure to check "complete inserts" and "save as file" towards the bottom in export.

Then, just press import in your new area, and load the file you saved previously.

[quietFinn]

Originally Posted by Lilymon

the reason why i entered phpMyAdmin is because i wanted to import the guestbook database from my old server.
i still need to figure out how is that done ..

You create the database in cPanel, then you go to phpMyAdmin, select that database from the list (if there are more than one), and then you import

[Lilymon]

first of all, i apologize im taking too long to respond ;__;

This is probably the easiest part

i seriously hope it is the easier part because right now the only thing stopping me from publishing my site is my old guestbook database at the previous server .. you have no idea how many guides i've read on transferring databases but nothing worked so far ..

here is how it goes ..
i used to use a viper guestbook script on my previous host's server and it has over 70+ precious entries i really dont want to lose *im an artist so every feedback i get on my works are important to me ;;___;;* ..
on my new server, i installed another guestbook script called lazarusgb both use mysql for storing data.
i have no idea if its possible or not, but i'd like to transfer the entries of the VPGB to Lazarusgb .. i tried doing so in phpmyadmin by making an export file [.sql] and import it to the new server but it still didn't work .. something about prefixes not matching or mysql access denied thing.

could you please help me with this ? is it even possible ?
if nothing worked then i'll probably have to manually transfer the entries but that feels like cheating XD

thank you muchly for your patience and help .. i really appreciate it .. really really appreciate it.

[Lilymon]

anyone please ?

[vtrain]

you cannot simply use a database setup for one guestbook on another guestbook. Eventually it could be possible to convert the initial database but I doubt you can find a free conversion utility for those two guestbooks. If you know SQL you could write one...

Vtrain

[Lilymon]

thats really sad to know =( .. if i knew sql i wouldn't be here asking for help ..
guess i'll have to start afresh with a new guestbook ..

thank you for your time vtrain ..

[tomowa]

I'm like you, I'm not smart enough to write a script do it.
It can be done though, it is going to take manually editing the database dump of the lazarus GB. You would install the Lazarus, then make a couple posts to it, to be able to see how the data is written to it. You would then d/l the database dump, and using a text editor, add the data to it from the viper db dump, in the format that Lazarus uses it. Then import the database back in.
I'm sure this seems like a long and complicated way of doing it, to those who are smart enough to write a script, but we all have to deal with the knowledge we have .
A member (Gail) at another forum I tend to www.webpagefun.com, did the same thing, converted her viper gb to Lazarus. It involved converting the timestamp from whatever format viper uses, to UNIX format that Lazarus uses. There are converters to do that. Gails GB had about 60 entries, and she worked her way through it and got it done http://www.homegail.com/guestbook.php.
I'm sure Gail would help walk you through it, if you contact her! Tell her Tom sent you

[Lilymon]

it is going to take manually editing the database dump of the lazarus GB

i've been thinking of doing something similar .. only now i have an idea of how to do it thanks to your explanation ='D

A member (Gail) at another forum I tend to www.webpagefun.com, did the same thing, converted her viper gb to Lazarus. It involved converting the timestamp from whatever format viper uses, to UNIX format that Lazarus uses. There are converters to do that. Gails GB had about 60 entries, and she worked her way through it and got it done http://www.homegail.com/guestbook.php

thats a relief to know .. i was starting to think its impossible to transfer entries from one gb to another .. i'll make sure i contact her if all my tries to fix the guestbook fails. im a fast learner so i hope she has the time to help me through.
thank you so very much for the help and the links .. you are awesome !

[tomowa]

Glad to help

I let Gail know you may be contacting her. This project sounds like fun, if anything else I can do to help let me know.

Tom

[Lilymon]

let Gail know you may be contacting her. This project sounds like fun, if anything else I can do to help let me know.

thank you so much ;;___;; .. i sent her a PM at webpagefun.com so i'll wait and see what happens .. i finally uploaded my website .. i still haven't made it public to my friends so far .. not until i get that GB fixed
thanks alot once again and again Tomowa for being so helpful ..

Hi
nice site

please, if you know anywhere about UFO activity - contact me ufos2006@yahoo.com
http://bestufo.org
Good Luck