Best Way to migrate nuBuilder to new webserver

Questions related to installing, setting up and configuring nuBuilder Forte

Best Way to migrate nuBuilder to new webserver

Unread postby icoso » Tue Mar 09, 2021 11:24 pm

I need to migrate my current nuBuilder installation to a different web server. What is the best way to do this?

I was going to:
1. Export my MySQL database (all tables and data) to an SQL files and export all data.
2. Create the database on my new provider and import the sql file.
3. Copy my entire database folder from my original server, and upload it into the same folder on the new server.
4. Modify the nuconfig file for the new server details.

What am I missing or is there anything else I should do instead of or in addition to the above?

Since my current and new web server already has phpMyAdmin installed as part of the Control Panel, Can I delete or eliminate the phpMyAdmin that comes with nuBuilder? IF yes, what files/folders do I need to remove from the nuBuilder install to do this? Is there any config file changes or any other file changes that I need to make to eliminate the phpMyAdmin from nuBuilder?
icoso
 
Posts: 176
Joined: Mon Feb 08, 2021 7:39 am
nuBuilder Version: 4.5

Re: Best Way to migrate nuBuilder to new webserver

Unread postby kev1n » Tue Mar 09, 2021 11:27 pm

I would also proceed in this way. You can delete the folder core\libs\nudb\ to get rid of phpMyAdmin.
kev1n
nuBuilder Team
 
Posts: 1771
Joined: Mon Oct 15, 2018 2:13 am
nuBuilder Version: 4.5

Re: Best Way to migrate nuBuilder to new webserver

Unread postby icoso » Wed Mar 10, 2021 12:49 am

Kev1n,

At the end of the SQL file export are several lines like this:

----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
CREATE ALGORITHM=UNDEFINED DEFINER=`dbkrist_ktdbuser`@`localhost` SQL SECURITY DEFINER VIEW `zzzzsys_object_list` AS select `information_schema`.`tables`.`TABLE_NAME` AS `zzzzsys_object_list_id` from `information_schema`.`tables` where `information_schema`.`tables`.`TABLE_SCHEMA` = database()
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

When I try to import this SQL export into my database I'm getting the following error:

MySQL said: Documentation
#1227 - Access denied; you need (at least one of) the SUPER privilege(s) for this operation

I am logged into my CPanel account as the "root" user. Im working with my host (which actually hosts both servers) to try to figure this out, but not getting anywhere. Any ideas that might cause this error?
icoso
 
Posts: 176
Joined: Mon Feb 08, 2021 7:39 am
nuBuilder Version: 4.5

Re: Best Way to migrate nuBuilder to new webserver

Unread postby kev1n » Wed Mar 10, 2021 1:26 am

Remove: ALGORITHM=UNDEFINED DEFINER=`dbkrist_ktdbuser`@`localhost` SQL SECURITY DEFINER

Code: Select all
CREATE  VIEW `zzzzsys_object_list` AS select `information_schema`.`tables`.`TABLE_NAME` AS `zzzzsys_object_list_id` from `information_schema`.`tables` where `information_schema`.`tables`.`TABLE_SCHEMA` = database()


... or alternatively rename the sql dump file to nubuilder4.sql, place it into nuBuilder's root directory and nuBuilder will import the file automatically the first the you log in.
kev1n
nuBuilder Team
 
Posts: 1771
Joined: Mon Oct 15, 2018 2:13 am
nuBuilder Version: 4.5

Re: Best Way to migrate nuBuilder to new webserver

Unread postby icoso » Wed Mar 10, 2021 2:58 am

Thank you. My hosting support was able to import the original using the original SQL file from an SSH login. I'll keep this for future reference.
icoso
 
Posts: 176
Joined: Mon Feb 08, 2021 7:39 am
nuBuilder Version: 4.5


Return to Installation

Who is online

Users browsing this forum: No registered users and 3 guests

cron