ATutor

moved to a different server

• chipwiegand
  

  2016-05-15 16:15:52

  moved to a different server

  I recently changed hosting services, and before the change occurred downloaded the entire database. On the new hosting server I uploaded the database intact.
  I then got my website back up and running, installed aTutor and have it running. Now I need to get the data from the "old" database (called atutor) into the "new" database (called atutor2). Both installations of aTutor are the same version.
  Is it as simple as just renaming the old database to the name of the new? (I doubt it.) Or should I do some import into the new? I don't see any help for this in the docs.
  Thanks.
  
  Things to describe:
  Operating system ATutor is installed on -
  ATutor version - 2.2.1(unknown - 2016-05-15 15:05:41)
  Patch #s applied - 0, no patches
  ATutor theme name - default_classic
  PHP version - 5.4.45
  MySQL version - 5.5.45-cll-lve
  Webserver & version - Linux 2.6.32-673.8.1.lve1.4.3.el6.x86_64
  Copies of error messages - no error messages
  Changes to default settings - don't remember the few made
  Web browser being used - Firefox
  ...and anything else relevant -

• chipwiegand
  

  2016-05-15 16:26:52

  Re: moved to a different server

  I did do this -
  in PHPMyAdmin I opened the database atutor2 and imported the data from the .sql file (atutor.sql) from the old server. The import reported it was successful. But it wasn't. In aTutor I see there are no courses. The imported tables have the prefix "AT_" but aTutor is expecting the prefix "atutor_".
  Is there a fix for this? Other than manually changing the name of every table.

• chipwiegand
  

  2016-05-15 16:40:03

  Re: moved to a different server

  If you are asking for help, provide lots of detail so problems can be reproduced.
  
  Things to describe:
  Operating system ATutor is installed on -
  ATutor version -
  Patch #s applied -
  ATutor theme name -
  PHP version -
  MySQL version -
  Webserver & version -
  Copies of error messages -
  Changes to default settings -
  Web browser being used -
  ...and anything else relevant -

• chipwiegand
  

  2016-05-15 17:07:42

  Re: moved to a different server

  I've been playing with the import function in PHPMyAdmin and have gotten some stuff imported, but only bits and pieces. There are many bits still missing. If I simply delete all the tables from the database and do a new import will I break the entire installation?

• greg
  

  2016-05-15 17:50:28

  Re: moved to a different server

  Just renaming the database should work, if you already have the old db transferred. Or renaming it in the config file, to point to atutor2 would also work.

• chipwiegand
  

  2016-05-16 10:32:59

  Re: moved to a different server

  I wish it were that simple, but for whatever reason, it's not proving to be. I have done both of your suggestions and there are problems, sometimes I cannot log in at all with any account, other times when I load the site log in page all I get is a blank white page. Another time when I loaded the login page I got part of the page, but no actual log in boxes. I have uninstalled/reinstalled atutor twice now. I have deleted and re-imported the database, tried renaming the database, tried modifying the config file. No matter what I do it looks like my only option is to grab the data from within each row in the database and paste it into the new installation of aTutor in a new content creation window. That will take quite some time to do, but I have yet to get any other method to work successfully.

• greg
  

  2016-05-16 10:48:26

  Re: moved to a different server

  Moving databases is not usually a problem. We've done lots of them. The best way to do it, is for a root user to just zip the mysql files from to old location, and as a root user upload them and unzip to the new location, then restart mysql. Files are typically found in /var/lib/mysql/[database name] on linux systems. Make sure user permissions on the new server are correct, using those on the old server as a model.
  
  Importing the files through phpmyadmin etc. runs the risk of breaking during import. And if you've done any content copy/paste from MSword, files may break on MSword quotations.
  
  You should not need to reinstall after a move, if the files from the old system have been copied over. You may need to adjust the content directory path in the config file, if the directory structure on the new server differs from the old server.
  
  Also be sure to clean any leftover atutor cookies from your web browser.