Uploading MySQL database on to the host site

Anon

Hi,

I am a new PHP + MySQL user. I have made a MySQL database on my PC at home. Now I want it to be uploaded to the host F2s.com server.

Can I do this ? Or is it that I have to use the database manager on the site and create the database and Tables again.

Best regards.

Anon

Read the mysql manual:

http://www.mysql.com/documentation/mysql/bychapter/manual_Tools.html#mysqldump

--------- snip ---------
mysqldump --opt database > backup-file.sql
You can read this back into MySQL with:
mysql database < backup-file.sql
--------- snip ---------

Grtz

Anon

http://phpwizard.net<br>
get phpMyAdmin and simple port the database.<br>Makes life very very easy.

Anon

Thank you for your reply. But I would like to clear some doubts. I have already downloaded phpMyAdmin. But how to use this.
I unzipped it to my hard-disk. But now what ? How to run this ? All other PHP scripts I make are in a (root) directory called c:\httpd\HtDocs ( I am using Omni web server on my home PC ). I type
http://localhost/myscript.php
in internet explorer and it runs in the browser. But how to run PhpMyAdmin ...

I am a new PHP programmer, so I would appreciate if you could help me with this...

Best Regards.

Anon

Yeah...this is how I would do it. Why rely on PHPMyAdmin?? Sure, it automates a lot for you, but then you have no idea what's going on....you just know it works. Learn how to do things from the command line, especially as a beginner, and then use the automation programs. That way you're not stuck if you suddenly can't use the program...

---John Holmes...

Anon

just make a new directory under c:\httpd\Htdocs...(call it admin or phpmyadmin or so)...and there you putt the files extracted from the phpmyadmin zip.
then you go to config.inc.php (or php3, depending on what you downloaded)...and there you set
$cfgServers[1]['user'] = YOUR_MYSQL_LOGIN_HERE'; // MySQL user (only needed with basic auth)
$cfgServers[1]['password'] = YOUR_MYSQL_PASSWORD_HERE'; // MySQL password (only needed with basic auth)

(depending on how you did set up your mysql server on your home pc...but i guess you already needed this when you made the database...so you know how to deal with this)

$cfgServers[1]['host'] = 'localhost'; // MySQL hostname
this should be set on 'localhost' (but is already set so in this script if i'm right)

and that's it...just run than the index.php (3) under your phpmyadmin directory (in I.E. like you do with your other php scripts)

in the left frame you will see your databases you have, and under them the tables in them...
click on the database, and then click "View dump (schema) of database" (choose: "Structure and data ") and GO

just install phpmyadmin on the new server or go to your command line there, and paste in the sql queries that were put out by phpmyadmin...easy!

i use this system all the time...i make everything at home (i don't have permanent connection you know)...and then let phpmyadmin make the queries i need for duplicating the tables on my serverspace...
i have phpmyadmin in a password protected directory on the site...and have had a lot of pleasure with it...surely John Holmes is right with his arguments about knowing the actual commands at the command line, but the tool is there...just use it...will save you some time and so on...programming is not about being tuff and knowing all commands out of your head...it's about making good, working programs...and how you do, is of secondary interest (i mean...writing your php code in notepad or in homesite makes no difference for the script, but is much more nice for the programmer...and so is it for this phpmyadmin tool...it's a super tool...and use it...especially if you just fiddle a bit around with mysql and so on...use your time for your program, and not for learning the commands you'll use two times

Jay wrote:

I am a new PHP programmer, so I would appreciate if you could help me with this...

Best Regards.

Anon

Thank you Rik, John, CCHCREG and Bert,

I have finally succeeded in working with MySQL on my site hosted at f2s.com.

I did this before Bert's suggestions to use PhpMyAdmin. I will try the way you explaine.

But right now this is the way I solved it -

I used MySqlDump to generate a text file.
MySqldump dbname > dbname.sql
I then logged on the dbserver in f2s and
gave the ( using browse ) file dbname.sql.
Thus the tables were created in my Databse

Thanks to the entire MySql community...

One great thing about software development is these small challenges. Thank God, I am into software development. Thanks to all once again.

Anon

Well now you know how to do it. Now is when you move on to PHPMyAdmin to make your life easier.

Anon

Hi,
This is not a reply to any message over here..but an extension to the existing Qns.
Please let me know how to solve my problem.

I am hosted with VServer and (Unix based) MySQL databse.
I have a data of 20000 records entered in my databse located in my local system. Now i want to upload the data and databse structure in to my account in VServer. Can some one guide me how to do this or where i can find the info...

many thanks in advance
Vasu

sepodati

Go back and read all of the answers in this thread again, it tells you exactly how to do it.

---John Holmes...