Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 12 of 12

Thread: Using MySQL

  1. #1
    Regular Coder
    Join Date
    Jul 2002
    Location
    U.S. (Wish Japan though)
    Posts
    141
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Using MySQL

    Well, uh.. I just started this today. I was reading the tutorial on it at webmonkey, but they make it assuming that your computer is being used as a server. Well, I was wondering, after you create the dump file and everything, what do you upload onto the servers to use it?

    I really hope I don't need to make my computer the server to use this...

  • #2
    Regular Coder
    Join Date
    Jul 2002
    Location
    U.S. (Wish Japan though)
    Posts
    141
    Thanks
    0
    Thanked 0 Times in 0 Posts
    *looks confused* Well, I know the server supports MySQL, they give a tutorial there, but it is slightly hard to understand and such... I guess I will have to try to read it again...

    I didn't bye anything... it is a free downlaod at http://www.mysql.com so... I was just wondering what fuiles I needed to upload. I tried just the .dump file, after I did all the creating and such, and it wouldn't work...

    Oh well, is it possilbe to use .txt files in replacement if MySQL won't work?

  • #3
    New Coder
    Join Date
    Jun 2002
    Location
    Paris, France
    Posts
    47
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Whats your server?

    And it is possible to use textfiles to manage data. But it is slower and not very secure.
    I don't suffer from insanity, I enjoy every single minute of it!

  • #4
    Regular Coder
    Join Date
    Jul 2002
    Location
    U.S. (Wish Japan though)
    Posts
    141
    Thanks
    0
    Thanked 0 Times in 0 Posts
    The server is http://www.tripod.lycos.co.uk and they allow MySQL, I checked on it... but I am not sure how to use it on the server.... Again, I might just re-read thier tutorial on it...

    And right now, all I am using txt files for is basically holding src-code data.... aka if a php page loads usign one variable, it loads a text file with the page source that related ot the variable..

    The worst that could happen is they see a page for fanfics in the txt file and not the php page.. *sigh* I am gonna put a protection on the directory so they can't just access the file-list of it...

    Thanks for your help

  • #5
    Regular Coder
    Join Date
    Jul 2002
    Location
    London, UK
    Posts
    126
    Thanks
    0
    Thanked 0 Times in 0 Posts
    If the server your hosted on says that it supports MySQL then you don't need to worry about fiddly binaries or source code downloaded from www.mysql.com, since it should already be installed. They should tell you on the hoster's site how to connect to your database, and often they'll have a nice little tool to help you administer it, like phpMySQLAdmin or something...

    Check around on the site first, then if you're still confused and can't figure it out you can always try contacting the web host for support...

    I did some poking around the Lycos/Tripod site and sure enough they use phpMySQLAdmin from what I can gather, all you need is to get your details and try finding out where you can login with it... then the rest is easy enough.
    Last edited by Mouldy_Goat; 07-07-2002 at 12:24 PM.

  • #6
    Regular Coder
    Join Date
    Jul 2002
    Location
    London, UK
    Posts
    126
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Oh and by the way, installing MySQL and Apache can be quite easy, I've heard people saying good things about it, I think you can download a bundle from the Apache site with MySQL included for windows, but I'm not sure.

  • #7
    Senior Coder
    Join Date
    Jun 2002
    Location
    paris, france
    Posts
    1,216
    Thanks
    0
    Thanked 0 Times in 0 Posts
    or you can get phpdev4 which has php, apache and mySQL
    and mySQL is a bit difficult to install on windows for the average user(it took me 3 days )
    Last edited by Jeewhizz; 07-06-2002 at 03:03 PM.
    photoshop too expensive? use the GIMP! www.gimp.org

  • #8
    Regular Coder
    Join Date
    May 2002
    Location
    London, England
    Posts
    367
    Thanks
    0
    Thanked 0 Times in 0 Posts
    To create or edit a database, the best bet is to download PHPMyAdmin. TO create stuff offline you'll need to install the various packages. Or you could download phpdev which does it all for you

    I know which option i'd choose

    Have fun,

    Jee
    Jeewhizz - MySQL Moderator
    http://www.sitehq.co.uk
    PHP and MySQL Hosting

  • #9
    Rockstar Coder
    Join Date
    Jun 2002
    Location
    USA
    Posts
    9,074
    Thanks
    1
    Thanked 328 Times in 324 Posts
    Originally posted by whackaxe
    mySQL is a bit difficult to install on windows for the average user(it took me 3 days )


    3 Days?! Jeez... It took me about twenty-five minutes to get MySQL, MyODBC, and phpMyAdmin running.
    OracleGuy

  • #10
    Senior Coder
    Join Date
    Jun 2002
    Location
    paris, france
    Posts
    1,216
    Thanks
    0
    Thanked 0 Times in 0 Posts
    not 3 whole days, about 3hours actually when i was dealing with it. i was getting error messages saying my password was incorrect when i had set it. i think that what i had done was set the password for root@% and not root@localhost which are differnet i suppose. in the end i used mysql GUI to sort all that out and everything was peachy!
    photoshop too expensive? use the GIMP! www.gimp.org

  • #11
    Rockstar Coder
    Join Date
    Jun 2002
    Location
    USA
    Posts
    9,074
    Thanks
    1
    Thanked 328 Times in 324 Posts
    Originally posted by whackaxe
    i was getting error messages saying my password was incorrect
    I had a similar problem too.

  • #12
    Regular Coder
    Join Date
    Jun 2002
    Posts
    553
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Jeewhiz mentioned phpadmin... I am working with a server where I can only see files thru ftp. I have no command line access, and therefore cannot use the command line to create a database. I am also limited to 50mb of storage. Judging from the info on phpadmin, there appears to be tens of thousands of files in that package - alll of which I would have to move vai ftp. I would love to have the tool, but it may not be practical. All I need to do is get the few commands done needed to create a database. Are there any scripts or more modest programs available to do this? Can it be done by a progrmm at all (I guess the answer has to be yes, since phpadmin can do it).
    I have hunted around, but have not turned up much other than descriptions of the command line way of doing it.

    G


  •  

    Posting Permissions

    • You may not post new threads
    • You may not post replies
    • You may not post attachments
    • You may not edit your posts
    •