Register

If this is your first visit, please click the Sign Up now button to begin the process of creating your account so you can begin posting on our forums! The Sign Up process will only take up about a minute of two of your time.

Results 1 to 4 of 4
  1. #1
    Member DanielGibbs's Avatar
    Join Date
    Jun 2004
    Location
    North Devon, England
    Posts
    63
    Member #
    6249
    Hey, say I create a MySQL database which I haven't for over a year, and want to put it on my website how do I? My website uses Cpanel so i can use My Admin or whatever that program is but i don't like using that I prefer coding in the monitor. Anyway. Say I create a DB can I save and uplaod it?

    Someone please explain how it works lol, i've never understood this.

  2.  

  3. #2
    Senior Member justlivyalife's Avatar
    Join Date
    Jul 2003
    Location
    Birmingham, UK
    Posts
    2,871
    Member #
    2374
    Depending on your version of phpmyadmin or similar, you should be able to export a database and its content into an sql file. On your server you can execute this sql file to install the database? Is this what you mean?
    justlivyalife - The future depends on what we do in the present. (Mahatma Gandhi)
    WDF Resources: WDF Rules
    Non-WDF: JavascriptSource | Dynamic Drive | phpBB | HTML-Kit | Winamp | Download Firefox | Morguefile

  4. #3
    Member DanielGibbs's Avatar
    Join Date
    Jun 2004
    Location
    North Devon, England
    Posts
    63
    Member #
    6249
    Hey justliv, it's easy-way off Mossoi's WDF forum :P. What I mean is that I create a database on MySQL monitor and want to know how to export a DB.

  5. #4
    Senior Member seanmiller's Avatar
    Join Date
    Sep 2003
    Location
    Glastonbury, UK
    Posts
    868
    Member #
    3263
    Liked
    1 times
    Not sure what "MySQL monitor" is...

    If you have an .sql file with your table definitions, the first line of which would be "use <databasename>", you have set up a user with a password and have granted it access to the database, and you have access to shell you should be able to load the file by doing...

    mysql -u username -p < myfile.sql

    ...you then need to type the user's password and you're "rocking"...

    Is this the sort of thing you were asking?

    Sean


Remove Ads

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
All times are GMT -6. The time now is 03:02 AM.
Powered by vBulletin® Version 4.2.3
Copyright © 2019 vBulletin Solutions, Inc. All rights reserved.
vBulletin Skin By: PurevB.com