Oh no! Where's the JavaScript?
Your Web browser does not have JavaScript enabled or does not support JavaScript. Please enable JavaScript on your Web browser to properly view this Web site, or upgrade to a Web browser that does support JavaScript.
Not a member yet? Click here to register.
Forgot Password?
  1. Home
  2. Discussion Forum
  3. PHPFusion 8 Support
  4. Installation Issues - 8
  5. Uploading MySQL Database Files via SSH?

Uploading MySQL Database Files via SSH?

Asked Modified Viewed 3,197 times
Back to Forum Index Previous Topic Next Topic
Print
Y
younis
Y
younis 10
Steve Younis
Superman Homepage - http://www.SupermanHomepage.com
Christopher Reeve Homepage - http://www.ChrisReeveHomepage.com/
Steve's Stuff - http://www.younis.com.au/
  • Member, joined since
  • Contributed 86 posts on the community forums.
  • Started 28 threads in the forums
  • Started this discussions
asked
Member

I'm moving my site to a new server. I have everything installed properly and all is running fine. I've managed to restore all the database files except one...

The problem is that the "fusion_posts" backup .gz compressed file is too large (4.2mb), and the server won't accept anything bigger than 2mb. I've tried to restore it using both the Fusion Admin and via phpMyAdmin.

I've been told to try upload it using SSH (Secure Shell) Access. However I don't know where PHPFusion installs the MySQL files. I thought it'd be in the Administration/db_backup directory, but I don't see anything in there.

Any ideas? Where do I upload this "fusion_posts" .sql file so that PHPFusion will be able to read all the Forum messages within it?

Thanks,
Edited by younis on 16-04-2010 07:34,
0 replies

2 posts

V
vinayan
V
Proud to be an Indian
  • Newbie, joined since
  • Contributed 3 posts on the community forums.
answered
Newbie

1.) Upload the SQL file via FTP Software on your webspace in for example your public_html folder

2.) Open SSH client and login as root

3.) Run the following command (don't forget to change the path and user and database information):

mysql -u databaseuser -p databasename < /home/username/public_html/database.sql

You will get:
"Enter password:" Enter database password.
0 replies
Y
younis
Y
younis 10
Steve Younis
Superman Homepage - http://www.SupermanHomepage.com
Christopher Reeve Homepage - http://www.ChrisReeveHomepage.com/
Steve's Stuff - http://www.younis.com.au/
  • Member, joined since
  • Contributed 86 posts on the community forums.
  • Started 28 threads in the forums
  • Started this discussions
answered
Member

Thanks. I finally figured out that I had to upload the .sql file to the server and have it run that command. I tried doing it with a .gzip file, but it didn't work. Had to upload the uncompressed .sql file (15mb in size), but that worked. :)
0 replies

Category Forum

Installation Issues - 8

Labels

None yet

Statistics

  • Views 0 views
  • Posts 2 posts
  • Votes 0 votes
  • Topic users 2 members

2 participants

Y
Y
younis 10
Steve Younis
Superman Homepage - http://www.SupermanHomepage.com
Christopher Reeve Homepage - http://www.ChrisReeveHomepage.com/
Steve's Stuff - http://www.younis.com.au/
  • Member, joined since
  • Contributed 86 posts on the community forums.
  • Started 28 threads in the forums
  • Started this discussions
V
V
Proud to be an Indian
  • Newbie, joined since
  • Contributed 3 posts on the community forums.

Notifications

Track thread

You are not receiving notifications from this thread.

Related Questions

Not yet