Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

how to input mysql values through ftp?

Status
Not open for further replies.
Chechen

Chechen

Technical User
Mar 14, 2002
2
US
We're in a website contest, the administrator for this contest installed Mysql for us and php rights..

how do we login through ftp or telnet to input our nuke.sql into the tables of mysql?
 
Sort by date Sort by votes
log in via telnet
and run
mysql -u yourlogin -pyourpassword < nuke.sql

or ask the admin to install phpMyAdmin
 
Upvote 0 Downvote
ok, how do you setup the table first?
im familiar w/ msqyladmin create nuke, but how do u do it remotely?

thank you
 
Upvote 0 Downvote
well i thought it's a sql script which creates the tables (sql extension?)
so what u need is dumping your database on the local machine (mysqldump -u user -ppasswd databasename > dump.sql)

add &quot;USE nuke;&quot; at the begining of the file (assuming your database name is &quot;nuke&quot;) , upload it and use the same command as posted above, just change the source file name
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

E
  • Locked
  • Question
MySQL calculator tools
Replies
0
Views
222
EdZzy
E
lupidol
  • Locked
  • Question
Cannot create new table in mySQL 3
Replies
6
Views
431
lupidol
lupidol
EdLentz
  • Locked
  • Question
Looking for suggestions on how to do this
Replies
4
Views
362
Chris Miller
Chris Miller
lupidol
  • Locked
  • Question
mysql cannot add rows with &quot;UNION&quot; 1
Replies
5
Views
391
Chris Miller
Chris Miller
dylim
  • Locked
  • Question
Why MySQL 5.7 is still getting updates
Replies
3
Views
331
spamjim
spamjim

Part and Inventory Search

Sponsor

Back
Top