upload DB from my comp to server!

[Anon]

Hello, I must upload my DB from my computer onto the server for my webpage, now I have dumped the context into a txt file, upload that to my folder via FTP ... what do I do to REDUMP that data so it re-creates all the tables with the data in it on the server?
I am in windows98

Thank you

[mwilson]

Hey,

Ideally you would use "mysql -u <username> -p <database> < <text file w/sql commands in>" then it should import them as necessary.

Matt

[Anon]

ok, where do I type that in? from telnet? from DOS ? in my webpage code?

[fandelem]

from telnet 🙂

[Anon]

I am very unfamiliar with telnet!!!
all those weird commands except USER and PASS I could only dicifer. ...when I type in
mysql -u -p < file.txt ...it says invalid command or something like that!

<sigh> starting to think I should just recreate and enter 723 items by hand! lol

fandelem wrote:

from telnet 🙂

[Anon]

Forget the telnet man.

try to make a textfile wich will look like this:

1-text
2-blabla

Create a database with to fields id and message, ten build a program wich put from that file in your database. If you can do that you will be able to upload your database. Put you text file and php file on the web, acces your php file and you will have your values in database. I ues this method and it works.

it's real easy and in this way you hav a "backup".