LinuxQuestions.org
Register a domain and help support LQ
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - General
User Name
Password
Linux - General This Linux forum is for general Linux questions and discussion.
If it is Linux Related and doesn't seem to fit in any other forum then this is the place.

Notices

Reply
 
Search this Thread
Old 09-07-2006, 03:07 PM   #1
Behrooz_Ice
LQ Newbie
 
Registered: Sep 2006
Posts: 2

Rep: Reputation: 0
Unhappy MYSQL Database Import


Hi All,
i want to import a big mysql database ( about 500 mb ) into my host.
our VPS Server is CentOS and use webmin.
please help me what am i do?
database name is: doost_forums.sql

also here is mysql version:
[root@doost ~]# mysql -V
mysql Ver 14.7 Distrib 4.1.20, for redhat-linux-gnu (i686) using readline 4.3

Regards,
 
Old 09-07-2006, 03:15 PM   #2
cygnus-x1
Member
 
Registered: Jul 2006
Location: Crisfield
Distribution: Slackware, CentOS, RedHat
Posts: 159

Rep: Reputation: 15
Not knowing your network constraints the easiest way is to simply have the administartor open an SSH port for you and you can SCP your dump to the server. I am not that familiar with webmin and I do not know if it has an file upload feature but I doubt it has a remote sql import feature. Have you looked at what webmin has to offer?

I assume your question is asking HOW to get your dump to the physical machine and not HOW to do a mysql import. That is real easy and google will have many hits on that as it is a common question.
 
Old 09-08-2006, 04:15 AM   #3
Behrooz_Ice
LQ Newbie
 
Registered: Sep 2006
Posts: 2

Original Poster
Rep: Reputation: 0
Hi,
i have a root account on vps and i was restore database by mysql command into ssh yesterday. but i import it by root mysql user. is it danger for security?
Sorry for poor english,
Regards,
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
how to import mysql database to oracle LinuxLover Linux - Software 1 07-22-2006 07:30 AM
MySQL Database Import sbb Linux - Software 1 06-04-2006 11:15 AM
MySQL import database akines Linux - Software 3 04-19-2006 01:14 AM
How to import a mysql database from backup WindowBreaker Slackware 6 03-16-2006 11:08 PM
Exporting MySQL error when trying to Import to another database. strez4prez Linux - Software 0 05-28-2004 11:43 AM


All times are GMT -5. The time now is 04:45 AM.

Main Menu
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
identi.ca: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration