Announcement

Collapse
No announcement yet.

SQL dump to move database to new server

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Wayne Luke
    replied
    "A System Error has occured. The software is experiencing a systems error.
    1) the system can't connect to the database.
    2) the database isn't complete and is missing required tables/fields.

    Leave a comment:


  • introtocryptos
    replied
    update: I did a forum upgrade and everything is working!

    No further support needed for this thread!

    Leave a comment:


  • introtocryptos
    commented on 's reply
    It may be of interest that when I try to access the forum without the www, the entire page comes up blank https://introtocryptos.ca/forums/

  • introtocryptos
    replied
    The error reported by the hosting is

    browser console shows error
    jquery.js:8630 Failed to load https://www.introtocryptos.ca/forums...se/getPhrases: No 'Access-Control-Allow-Origin' header is present on the requested resource. Origin 'https://introtocryptos.ca' is therefore not allowed access. The response had HTTP status code 404.
    Can anyone help me with this?

    Leave a comment:


  • introtocryptos
    commented on 's reply
    I am also getting this error - (spelling error is not mine ;-)
    And wonder how can I get the error logs?

    "A System Error has occured.
    The software is experiencing a systems error.

    You should attempt to repeat your last action. If this error occurs again, please contact the site administrator."

  • introtocryptos
    replied
    Thank you Wayne Luke - I was able to successfully move the database, and almost have the forum running smoothly on the godaddy hosting under the new domain.

    I can login to the admincp and all seems to work fine there, and the front of the forum now provides a generic error message 'That action could not be completed. Please try again, and if this occurs again please contact the system administrator and tell them how you got this message.'

    Somewhere on these support forums it was suggested it must be a database issue, I have run the repair database commands and repair table commands - and that worked but did not fix my issue. I know it must be a simple setting that I am missing - and determined to get it sorted out today.

    Leave a comment:


  • Wayne Luke
    replied
    It will be created on the server. You will have to transfer it to your local machine through some other means. That command just creates the file. If you leave off /path/to it will create the dump file in the current directory.

    Code:
    mysqldump --opt -Q -uUSERNAME -p DATABASENAME > mydatabase.sql

    Leave a comment:


  • introtocryptos
    replied
    Thank you In Omnibus - I needed that tip!

    I was able to successfully move the forum files and move the database using Putty and SSH - and feel great accomplishment!

    These two screenshots demonstrate what I did for Part Two of the instructions for Appendix: Technical Documents / Moving Servers / 2) Backing-Up the Current Database. Due to distractions while implementing, I did not get screenshots for parts Three and Four but hope this helps someone.

    Regards and thank you for the support on this forum!

    Introtocryptos



    Click image for larger version  Name:	movingdatabase-puttyscreenshot2of2.jpg Views:	1 Size:	45.6 KB ID:	4396778
    Last edited by introtocryptos; Tue 21st Aug '18, 3:11am.

    Leave a comment:


  • In Omnibus
    replied
    What are you entering as the path? That should be the location of the SQL file.

    I recommend using the absolute path to the root directory (outside the public_html directory)

    It's usually something like var/www/html/home/username/html

    Leave a comment:


  • introtocryptos
    started a topic SQL dump to move database to new server

    SQL dump to move database to new server

    I'm following the instructions (Appendix: Technical Documents / Moving Servers / 2) Backing-Up the Current Database) and finally achieved login success with PUTTY.

    After trying the command 'mysqldump --opt -Q -uUSERNAME -p DATABASENAME > /PATH/TO/DUMP.SQL' a number of different times, I can't seem to find the DUMP.SQL file

    Is this file supposed to be on my computer? Or is the /path/to/ on the hosting environment?

    NOTE: I removed /path/to/, as the instructions say 'If you did not specify a full directory, the file will be in the directory you are currently in.' - but I don't know what directory I'm in as I have no skill with working in command line - and I cannot find the backup file.

    Appreciate any help.

    Doug
widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
Working...
X