Hi Guys would really appreciate any help here
I have just updated my xammp version and i cannot get back into my osticket pages
i have 3 ticket areas created and i have been able to recover 2 of them via phpmyadmin but the address for them are not recognised
the third and propably most important one is not allowing me to import it to phpmyadmin

i have made several different backups including the sqls for php and htdocs, if needs be i can pull it all back to a previous day aswell

so my main questions are what would cause my exported file to not allow for import and is there anything that i should check on phpmyadmin to allow the other two pages to be accessible

    Richard-Treanor so my main questions are what would cause my exported file to not allow for import and is there anything that i should check on phpmyadmin to allow the other two pages to be accessible

    The first thing that comes to mind is that phpmyadmin (like all PHP applications) has a logical limit to the size of files (.sql) that can be uploaded to it. It also has a finite amount of memory that it can use. What the file size compared to the ones that do work? I have a couple sites that I cannot restore from a back up on via phpmyadmin because of the size of the file.

    Do you have SFTP/SHH access to the server? You could use SFTP to send the .sql file to the server, and then access it via command line (SSH) and manually run the restore.

        5 months later

        ntozier
        Hi ntozier
        thanks for your reply and sorry i haven't replied in a few months , our main ticket system DB is 125mb where the other 2 are 15mb and 2mb.
        I should have SFTP access to the server how would i go about doing this and would it allow for a file size of 125mb?

          You would reach out to your host and get instructions on how to SFTP files.
          And how to SSH.
          Then you would need to look up mysql command line for restoring the database.

          I imagine that it would be something like:
          mysql -u <username> -p <databasenamne> < theNameOftheFile.sql

            a month later

            ntozier

            Thanks for your help with this issue, although i didn't end up using your suggestion i did get another solution to work for me.

            the solution i used involved increasing the database size in the php.ini file - see link below
            https://stackoverflow.com/questions/12707822/how-to-increase-import-size-limit-in-phpmyadmin

            after increasing the file size i created new backup for each of my databases and my privileges for each database and copied the php.ini fle to a backup folder and followed these instructions

            1: uninstall xampp removing all data except the HTDOCS folder
            2: restart server
            3: Install xampp, do not run
            4: Restart server
            5: Check if xammp has started on startup (if so close it)
            6: run Xampp as admin
            7: install MySQL and Apache
            8: start both services
            9: click on the apache config and browse the php folder
            10: copy the php.ini folder from the backup folder to the PHP folder (this will allow us to recover larger DB files)
            11: Click on the MySQL admin button this will open PHPMyAdmin
            12: Click new and create the osticket DB
            13: when this is created click into it and go to import select the .sql file from your backup folder
            14: allow this to run (may take some time)
            15: you may get an error similar to mysql 1050 table already exists (this table does not exist and should not affect the recovery)
            16: click on SQL and import the privileges from the old data base

            hope this helps someone else 😁

              ntozier changed the title to [resolved] Xammp update.

              @Richard-Treanor Thank you for posting your solution. I'll mark this as resolved and close it. Please feel free to start a new thread if you have another issue.

              Write a Reply...