Uploaded image for project: 'Website'
  1. Website
  2. WEBSITE-1391

Commands may be incorrect for some linux/msyql combinations

    XMLWordPrintable

Details

    • Bug
    • Status: Closed
    • Minor
    • Resolution: Fixed
    • None
    • None
    • uname -r
      3.10.0-957.12.2.el7.x86_64

      Mysql Server version: 10.2.25-MariaDB MariaDB Server

    Description

      On this page:

      https://www.phpbb.com/support/docs/en/3.1/kb/article/transferring-your-board-to-a-new-host-or-domain/

       

      These two lines may not work on some linux systems:

      gunzip < NAME_OF-FILE.GZ | mysql -u USERNAME -p PASSWORD --default-character-set=utf8 DATABASE_NAME

      and

      mysql -u USERNAME -p PASSWORD --default-character-set=utf8 DATABASE_NAME < NAME_OF-FILE

       

      In many cases you will want to leave the PASSWORD out and then enter it at the prompt.  Some hosts have disabled it due to security implications of having the password in the command, so the commands should be:

      gunzip < NAME_OF-FILE.GZ | mysql -u USERNAME -p --default-character-set=utf8 DATABASE_NAME

      <then enter password at the prompt>

      and

      mysql -u USERNAME -p --default-character-set=utf8 DATABASE_NAME < NAME_OF-FILE

      <then enter password at the prompt>

       

       

       

       

      Attachments

        Activity

          People

            Unassigned Unassigned
            CentaurAtlas CentaurAtlas [X] (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: