Professional Web Applications Themes

mySQL to Apache server - Macromedia Dreamweaver

Hi, I have been developing an app. locally on my home machine using PHP and a mySQL database. I would now like to lift all up on to my website hosted on an Apache server. I have no problem with uploading the site files, BUT how do I move the myself database?? Any pointers gratefully received Coddie --- This Mail is Certified Virus Free Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.507 / Virus Database: 304 - Release Date: 04/08/2003...

  1. #1

    Default mySQL to Apache server

    Hi,
    I have been developing an app. locally on my home machine using PHP and a
    mySQL database.

    I would now like to lift all up on to my website hosted on an Apache server.

    I have no problem with uploading the site files, BUT how do I move the
    myself database??

    Any pointers gratefully received

    Coddie


    ---
    This Mail is Certified Virus Free
    Checked by AVG anti-virus system (http://www.grisoft.com).
    Version: 6.0.507 / Virus Database: 304 - Release Date: 04/08/2003


    Coddie Guest

  2. #2

    Default Re: mySQL to Apache server

    You should really get in touch with your host and have them install the
    database for you on their MySQL server.

    -- Mike

    Coddie wrote:
     

    MLangner-MMTS Guest

  3. #3

    Default Re: mySQL to Apache server

    Oh Ok,
    So it is not simply a matter of uploading, like an ACCESS db ?

    Coddie

    "MLangner-MMTS" <com> wrote in message
    news:bgtul2$snu$macromedia.com... [/ref]
    a [/ref]
    server. 
    >[/ref]


    ---
    This Mail is Certified Virus Free
    Checked by AVG anti-virus system (http://www.grisoft.com).
    Version: 6.0.507 / Virus Database: 304 - Release Date: 04/08/2003


    Coddie Guest

  4. #4

    Default Re: mySQL to Apache server

    I haven't done this, but have the same problem coming up - needing to move
    dbase schema and data from one MySQL installation to another.

    My plan is to use the tool phpMyAdmin which has an export function. You can
    export the schema and data as SQL text. Then just run this against your new
    database. Should build the tables and insert the data.

    You can find phpMyAdmin at http://www.phpmyadmin.net/. A very cool and
    useful tool.

    Walt


    "Coddie" <fr> wrote in message
    news:bgtrnt$n5e$macromedia.com... 
    server. 


    Walt Guest

  5. #5

    Default Re:mySQL to Apache server

    MySQL has command line export and import database functions.
    Also, a PHP front-end like PHPMyAdmin can do export and import.

    HTH
    -Rb



    Rb- Guest

  6. #6

    Default Re: mySQL to Apache server

    No. You could possibly export the database on your own to your remote
    server using a MySQL front-end like PHPMyAdmin, but you would still need
    to ask your host if they can let you connect remotely to their server.

    -- Mike

    Coddie wrote:
     [/ref]
    >
    > a
    > [/ref]
    >
    > server.

    >>[/ref]
    >
    >
    > ---
    > This Mail is Certified Virus Free
    > Checked by AVG anti-virus system (http://www.grisoft.com).
    > Version: 6.0.507 / Virus Database: 304 - Release Date: 04/08/2003
    >
    >[/ref]

    MLangner-MMTS Guest

  7. #7

    Default Re: mySQL to Apache server

    Many thanks for the reply Walt,
    I have created a .sql text file using PHPMyAdmin,
    When you say "just run this against your new database" what exactly do you
    mean ?

    Coddie


    "Walt" <com> wrote in message
    news:bgu2cd$6s4$macromedia.com... 
    can 
    new [/ref]

    > server. 
    >
    >[/ref]


    ---
    This Mail is Certified Virus Free
    Checked by AVG anti-virus system (http://www.grisoft.com).
    Version: 6.0.507 / Virus Database: 304 - Release Date: 04/08/2003


    Coddie Guest

  8. #8

    Default Re: mySQL to Apache server

    As MLangner-MMTS noted in another post, you may have an issue getting your
    ISP to allow you to remotely connect to their MySQL database machine. From
    what I see, this is often only accessable via an intranet at their site, for
    security reasons. Since the webserver also runs on the intranet, it can
    access it.

    So, what to do? Again, I haven't done this yet, myself. But seems to me
    that you could just write a PHP script on your new ISP webserver that
    executes this SQL to create the database & tables and load the data. This
    would be a throwaway page/script that you only need to run once. Since it
    can directly access the database locally, you shouldn't have access
    problems.

    Walt


    "Coddie" <fr> wrote in message
    news:bgu36l$8cr$macromedia.com... [/ref]
    move 
    > can 
    > new [/ref]


    Walt Guest

  9. #9

    Default Re: mySQL to Apache server

    Many thanks Walt
    I will give a try

    Coddie


    "Walt" <com> wrote in message
    news:bgu3sb$9n2$macromedia.com... 
    From 
    for [/ref]
    you [/ref]
    > move [/ref][/ref]
    You [/ref][/ref]
    your [/ref][/ref]
    and [/ref]
    >
    >[/ref]


    ---
    This Mail is Certified Virus Free
    Checked by AVG anti-virus system (http://www.grisoft.com).
    Version: 6.0.507 / Virus Database: 304 - Release Date: 04/08/2003


    Coddie Guest

  10. #10

    Default Re: mySQL to Apache server

    Walt wrote:
     

    If you have a shell-account on the remote server than you can do it like
    this: Open a shell or DOS-box on your machine and type

    mysqldump -u Username -pPassword DBName > backup.sql

    (Attention: There's _no_ space between -p and the password!)

    This will dump the whole database DBName with all tables to the file
    backup.sql. Upload this to the remote server, login and type

    mysql -u Username -pPassword DBName < backup.sql

    Voila.

    HTH
    Micha
    Michael Guest

Similar Threads

  1. Replies: 0
    Last Post: January 29th, 02:03 PM
  2. which server for PHP, Mysql and apache for windows?
    By _mario.lat in forum PHP Development
    Replies: 1
    Last Post: July 11th, 10:41 PM
  3. Replies: 3
    Last Post: October 28th, 03:24 PM
  4. Replies: 0
    Last Post: October 15th, 02:49 PM
  5. is it possible to access mySQL using lingo in apache server?
    By Nikijackson webforumsuser@macromedia.com in forum Macromedia Director Lingo
    Replies: 3
    Last Post: September 26th, 02:03 AM

Bookmarks

Posting Permissions

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

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139