Upload Db via SSh issue
11-20-2017, 09:52 PM
(This post was last modified: 11-20-2017, 10:26 PM by testing.)
I was finally able to login into my phpmyadmin but I can't upload my db from the file location.
Here is the command i followed
[root@server ~]# mysql -u test -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 4031980
Server version: 5.1.73 Source distribution
Copyright © 2000, 2013, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql> mysql -u test -eda2aj zadmin_test < /var/sentora/hostdata/zadmin/public_html/site_com/backup.sql
->
But nothing happens when I did it.
Also I used this command but gets the same thing
< /var/sentora/hostdata/zadmin/public_html/site_com/backup.sql
->
What to do now? What step i am doing wrong?
Ok, Solved. This command system didn't work for me at all. I had to google to find out the issue to get resolved. I had it tested earlier from same link but I missed something on reading so I read again and I am able to solve it.
This link works the best : https://in.godaddy.com/help/importing-my...a-ssh-7588
Here is the command i followed
[root@server ~]# mysql -u test -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 4031980
Server version: 5.1.73 Source distribution
Copyright © 2000, 2013, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql> mysql -u test -eda2aj zadmin_test < /var/sentora/hostdata/zadmin/public_html/site_com/backup.sql
->
But nothing happens when I did it.
Also I used this command but gets the same thing
< /var/sentora/hostdata/zadmin/public_html/site_com/backup.sql
->
What to do now? What step i am doing wrong?
Ok, Solved. This command system didn't work for me at all. I had to google to find out the issue to get resolved. I had it tested earlier from same link but I missed something on reading so I read again and I am able to solve it.
This link works the best : https://in.godaddy.com/help/importing-my...a-ssh-7588