Linux - NewbieThis Linux forum is for members that are new to Linux.
Just starting out and have a question?
If it is not in the man pages or the how-to's this is the place!
Welcome to LinuxQuestions.org, a friendly and active Linux Community.
You are currently viewing LQ as a guest. By joining our community you will have the ability to post topics, receive our newsletter, use the advanced search, subscribe to threads and access many other special features. Registration is quick, simple and absolutely free. Join our community today!
Note that registered members see fewer ads, and ContentLink is completely disabled once you log in.
If you have any problems with the registration process or your account login, please contact us. If you need to reset your password, click here.
Having a problem logging in? Please visit this page to clear all LQ-related cookies.
Introduction to Linux - A Hands on Guide
This guide was created as an overview of the Linux Operating System, geared toward new users as an exploration tour and getting started guide, with exercises at the end of each chapter.
For more advanced trainees it can be a desktop reference, and a collection of the base knowledge needed to proceed with system and network administration. This book contains many real life examples derived from the author's experience as a Linux system and network administrator, trainer and consultant. They hope these examples will help you to get a better understanding of the Linux system and that you feel encouraged to try out things on your own.
Click Here to receive this Complete Guide absolutely free.
i have just switched from one hosting company to my own dedicated server and i had a forum on the old server that used a mysql dB.
Now i have exported the db to a .sql file and im using my test server to test this out.
I ahve installed the forums on the new server, started up a new dB and it is working fine.
What i want to do now is upload the old .sql file into it. I never had a problem before using the phpmyadmin tookl but now it times out.
So i figured i would upload the file to the server and run the mysql command.
I uploaded it but when i run the command it doesnt find the uploaded file.
my question is , what folder do i need to upload this .sql file to in order for mysql to see it when i run the command?
I am su to root
The command im running is mysql -u username -ppassword newdbname <new.sql file;
Is this right? it appears to want to work but tells me :
su: ivbd.sql: No such file or directory
I just logged onto my ftp onto the root account and dropped it in that folder, is that wrong?
How did you export out your DB in MySQL? did you include all INSERTs? If you did, you need to take these steps via MySQL CLI:
1. login AS root or user with all SUPER priv into MySQL
2. create empty DB
3. type (without single quotes) 'use [NEW DB NAME];'
4. run this command : (without single quotes or brackets) '\. [file/full/path/here/][FILENAME].sql;'
5. grant the appropriate user ID its priv to read / write to new DB
6. Test connection