which sql database am I using & how do I change it?

  • Resolved juliatrops

    (@juliatrops)


    16 years, 6 months ago

    I am updating my blog after about six months of inactivity –

    I installed the newest wp version a few days ago, updated the plugins (some of which wont work because I get the error that I am using php 4) – well,

    I go to my sql database page with my hosting manager, and I now have another wp database – that runs on 5. So I now have a database that is running php4 and one that is running php5.

    I am trying to run Donation Cloud by Zirona, and am not able to have the links appear for the donors, which I understand is an issue with not having php5-curl.

    because of these two errors (not able to upgrade plugins, and the curl error), I assume I am still running wp on the php 4 version – how do I get the wp to go on to the 5 and still keep all my data?

    The only thing I have done right now is backed up both databases.

    I am not sql php savvy so am being very cautious. Any help would be greatly appreciated.
    Thank you
    Julia

Viewing 15 replies - 1 through 15 (of 19 total)
1 2
  • MichaelH

    (@michaelh)

    16 years, 6 months ago

    Your database is described (DB_NAME, etc) in your wp-config.php file. Might need to user your host’s file manager or FTP to look at that file.

    Note: don’t confuse PHP with MySQL as it relates to versions. Talk to your host about upgrading your PHP.

    Thread Starter juliatrops

    (@juliatrops)

    16 years, 6 months ago

    Hi there! thank you so much for your reply.

    In MySQL, this is what it looks like:
    http://www.juliatrops.com/mysqldatabases.jpg

    I don’t know where that third entry (php5) came from, it was updated by godaddy?

    I must apologize – as an artist, I tend to focus on the art stuff, and then when I have to come back in to this world it takes me a bit to re-make the connections –

    If someone could tell me whether or not I am correct in the following, that would be great:
    a. the database (php5) was updated by godaddy
    b. in order for the wordpress blog to be accessing this php5 database, I need to
    – delete the php4 db (this has already been backed up) then
    – rename the php5 db, then
    – import the php4 db information into the php5 database.

    Is that a correct understanding? If not please do let me know (but stop chuckling first. heheh.)
    Thank you!
    Julia

    MichaelH

    (@michaelh)

    16 years, 6 months ago

    MAJOR CHUCKLE….

    a. database is MySQL and it shows as a MySQL version 4 database.
    b. version 2.84 of WordPress only requires MySQL version 4.0. Beginning with 2.9 you will need MySQL 4.1.2 or greater.

    MySQL is the database that houses your data such as posts, pages, comments, categories, tags, and users.

    PHP is the programming language that WordPress uses. PHP 4.3 or higher is required for WordPress.

    So again, talk to godaddy about upgrading PHP to version 5 if you have plugins that require that.

    As it stands right now, don’t know that you need to change anything with your databases.

    Thread Starter juliatrops

    (@juliatrops)

    16 years, 6 months ago

    ah!!! light went on! Okay, I was misunderstanding that table to read as the versions being php 5. Funny how we see something and we want it to fit what we want.

    Thank you for being SO PATIENT! honestly, I really appreciate that.

    I will ask godaddy about upgrading to php5 – I do have plugins (ie the donation cloud in support of my 2010 residency) that require 5 – and something called “curl”.

    Thank you so much again. Cross your fingers that godaddy can do that…(?)

    okeedoke – went to godaddy and ran a search on php version 5. turns out I can update it myself under “add-0n languages” – so did that. jsp/servlets are activated – is that okay?

    Sorry to ask again- do I need to do anything else for wp ie to make the change recognized or will it all just magically appear. lol!

    Thread Starter juliatrops

    (@juliatrops)

    16 years, 6 months ago

    just did a check on the blog – error establishing connection – so maybe the files are being updated as I wait with bated breath.

    esmi

    (@esmi)

    16 years, 6 months ago

    Double check your wp-config.php file to see which database you’re connecting to (I’m assuming it should be the older MySQL 4 database) and that the username and password are correct.

    Just out of curiosity, have you looked in the MySQL 5 database to see what’s in there?

    Thread Starter juliatrops

    (@juliatrops)

    16 years, 6 months ago

    Hi! I have not been able to get in to any of the sql databases, at all!!! I keep getting an error 1045 with my isp address (I think that is mine) when I try to log in.

    I’ve changed the password and still can’t get in – I have a godaddy ticket in about that as well. šŸ™

    edited: the blog db is not juliablog it is the jul0828701451896!

    I was on the blog this am, and when someone donated using the donation form, their link did not show up. after some searching, I found a note by the developer saying that the cloud may not show up because of “curl” – curl needs to be installed (or accessed or something!) and also I have to use php5.

    So I am trying to get their link to show up, and have to have this other stuff up and running in order for that to occur.

    esmi

    (@esmi)

    16 years, 6 months ago

    What about your backups? Do you have copies locally? I was just wondering whether GoDaddy updated your database at the same time that they started your move to PHP5.

    Thread Starter juliatrops

    (@juliatrops)

    16 years, 6 months ago

    I do have local copies yes. That was the first thing I did. šŸ™‚

    I also just looked at the wp-config.php file – and the db is the long name, and the pwd to open the manager is now the same as the one that is in the wp-config file.

    So do you think I should restore the db to the version 5 sql? I can do that w/o going in to the sql panel.

    YES!!! blog is back!

    okay now what? lol!

    wondering do I need to update anything at all?

    esmi

    (@esmi)

    16 years, 6 months ago

    No – I wouldn’t mess with any of the databases for now. Have you contacted Godaddy and asked them about an upgrade to PHP5?

    Thread Starter juliatrops

    (@juliatrops)

    16 years, 6 months ago

    yes, went on my domain manager, and I could do that myself, so did it. that was when the blog was unreachable –

    also, there is something called jsp/servlets that are activated – is that okay?

    I’m just trying to figure out how to get that fellow’s website to appear in the donation cloud. If you go on the blog
    blog.juliatrops.com there is a widget on the right, that if someone donates then their website should show up according to their donation. well this fellow donated this morning, and I was on php4 – so of course it didnt show up. now that I am on 5 (assuming I am, how can I check?) I need it to show up. will it just show automatically or is there a refresh of some kind that I need to do?

    edited to add: I can now get in to my sql so at least that problem is solved.
    another edit: browsing the wp_donations db, I can see this fellows name and website. So I know it’s in there, I just need it to show up now on the blog.

    esmi

    (@esmi)

    16 years, 6 months ago

    There’s link in the tag cloud but no url or link text. From the source of your home page:

    <a href="" title="10.00 USD, 2009/10/08" style="font-size: 13.55px;"/>

    Is this a custom widget?

    Thread Starter juliatrops

    (@juliatrops)

    16 years, 6 months ago

    yes, it was made by the fellow who owns this website:
    http://www.zirona.com/
    http://www.zirona.com/software/wordpress-donations-cloud/

    the coding should insert the fellows link where it says a href… but it couldnt cuz I was on php4 before.

    maybe I can edit it myself?

    esmi

    (@esmi)

    16 years, 6 months ago

    I’d suggest contacting him. Given that an empty link is being inserted, it could be that the widget isn’t functioning correctly. Or the fact that you were running PHP 4 without cUrl when this donation was made has meant that the data in the db isn’t complete. Either way, the original developer is the best person to troubleshoot this.

    Thread Starter juliatrops

    (@juliatrops)

    16 years, 6 months ago

    yes, that is what I thought – that by running with php4, the link was not recognized. it is in the db though, but the connection is not made between the two php files. just want to know how to make that connection happen. I will write him.
    Thank you for your help!

Viewing 15 replies - 1 through 15 (of 19 total)
1 2

The topic ‘which sql database am I using & how do I change it?’ is closed to new replies.