473,324 Members | 2,254 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,324 software developers and data experts.

uploading a mysql database using SSH termimals hlp

24
hi i have problems uploading my database using phpmyadmin n i want to load it using the ssh termal in setd of phpmyadmin.

can anyone hlp
Feb 19 '07 #1
5 5590
ronverdonk
4,258 Expert 4TB
using the ssh termal in setd of phpmyadmin.
What is the "ssh termal in setd of phpmyadmin"?

Ronald :cool:
Feb 19 '07 #2
hdf
24
What is the "ssh termal in setd of phpmyadmin"?

Ronald :cool:
it means that i want to upload the database using mysql rather then phpmyadmin. pgpmyadmin keeps on bomming out when i run the scripts
Feb 20 '07 #3
ronverdonk
4,258 Expert 4TB
Then what format are you using for the upload? A file with SQL statements that must be passed or you want to use the PHP (or other server) language to use the mysql_* commands to insert the data into your tables?

You gotta give some more info, we cannot guess to what you want to do!

Ronald :cool:
Feb 20 '07 #4
hdf
24
Then what format are you using for the upload? A file with SQL statements that must be passed or you want to use the PHP (or other server) language to use the mysql_* commands to insert the data into your tables?

You gotta give some more info, we cannot guess to what you want to do!

Ronald :cool:
hi
server:
remote Linux server
mysql
php 5
Apache
PHPMyAdmin

I want to tellnet to my remote server useing ssh then access the mysql in command line and upload sql batch from my local pc to the server. The files is .sql batch file file that i want upload to the database.

Insted of using PHPMyadmin i want to use the remote server via tellnet to run the batch file dat will fill the database becouse phpmyadmin is unable to do it coz of the size of the batch file is to small. I need to now how to do it and wat commands i must use to make it work

i hope dis will be enough infomation i hope else contact me for more

Thank you
Feb 23 '07 #5
ronverdonk
4,258 Expert 4TB
If you want to load your .sql file into a database use the 'mysqldump' utility that can be called from the command line. You can read the dump file back into the server like this:
Expand|Select|Wrap|Line Numbers
  1. shell> mysql db_name < backup-file.sql
See the MySQL manual on this at MySQL dump utility

You might also find useful information in THIS THREAD

Ronald :cool:
Feb 23 '07 #6

Sign in to post your reply or Sign up for a free account.

Similar topics

6
by: Ralph Freshour | last post by:
I'm trying to code the ability for my users to upload up to photo's to mysql database - can someone point me in the right direction as to how this might be done in php? Perhaps a tutorial or some...
10
by: John Smith | last post by:
I know that uploading an image to a database has been covered, oh, about 3 trillion times. However, I haven't found anything covering uploading to a MySQL database with .net. Please don't...
9
by: C.Joseph Drayton | last post by:
Hi All, I have a web site I am developing, and have a question. I would like members to be able to upload pictures. Do you think they should be saved as individual files or should they be put...
5
by: Chris | last post by:
I have a meetings section I'm developing on our intranet. Using PHP/MySQL. Meeting info and Meeting docs reside on 2 related tables in the db. Users may want to upload anywhere from 1 to 10 or...
5
tolkienarda
by: tolkienarda | last post by:
hi all i need to allow people to upload images to my site and then save them in a mysql database. i've looked at some prebuilt scripts using iframes but i don't think that will work for me. I want...
0
by: lyealain | last post by:
hi guys.. i have spent up my time looking and understanding the sample code from everywhere for uploading picture into mysql database by using asp script.. but i found it very hard to understand......
0
by: shubhendu pyne | last post by:
how to upload system information(unix box) to MySql database's(running in another unix box) respective tables using a script only..i.e once script runs all the informations like...
221
Atli
by: Atli | last post by:
You may be wondering why you would want to put your files “into” the database, rather than just onto the file-system. Well, most of the time, you wouldn’t. In situations where your PHP application...
2
by: matech | last post by:
I have a problem with uploading special characters from excel files to mysql 5. It doesn't matter if I use UTF-8 or iso-8859-1 when uploading the trademark ™ symbol. htmlspecialchars() or...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.