"Easy" way to go back to clean install?

[orangezero]

I am able to get nubuider 4 running on Windows via the XAMPP software as directed in the youtube video. Software seems really great.

After a bit of messing around, I tend to mess up the menus and eventually make nuBuilder inoperable when I try to revert to a clean default install. My only workable solution is to literally uninstall and reinstall all of the XAMPP and recopy nuBuilder files. I'm sure there is an easier way. I just need to clear out my forms so I can start learning again.

I guess I also don't understand what files need backing up to keep both the forms I've made and the actual data in the database. I believe I remember reading it was all in one file. Would most people do this via phpmyadmin, or via a command line? Being new to MySQL, phpmyadmin, and nubuilder4, it gets a bit confusing.

As a side topic, is there some reason why I've had zero luck with nubuilder4 on Ubuntu (raspberry pi 4 4gb specifically)? I can't get to a working nuBuilder login screen using multiple ubuntu versions, or on lxd, or on docker. Months ago it was installation errors, but now I believe I'm mostly erroring in the network setup. In my latest failed attempt the logs say … /var/www/html/jquery/jquery.js is denied because search permissions are missing on a component of the path.

[gerese]

1.Go to: MySQL command line
https://stackoverflow.com/questions/698 ... or-windows

2. Type next commands in MySQL command line

mysql -h127.0.0.1 -u root -p

DROP DATABASE nubuilder4;

CREATE DATABASE nubuilder4;

USE nubuilder4;

SET storage_engine=MYISAM;

ALTER DATABASE nubuilder4 DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;

SOURCE C:/xampp/www/nubuilder4/nubuilder4.sql;



Relogin in NuBuilder

[admin]

orangezero,

If you delete all the tables in nuBuilder Forte, the next time you log in a new clean copy of the database will be created automatically.


Steven

[kev1n]

I guess I also don't understand what files need backing up to keep both the forms I've made and the actual data in the database..

If you delete all tables in nuBuilder, the forms you've made will be gone as well.
Therefore, just run the Update Button in nuBuilder to restore all nuBuilder tables/forms. (make sure the original/unchanged nubuilder4.sql is in nuBuilder's root directory)

[orangezero]

Okay, thank you all very much for the replies. These have been 100% better than google searches...

So, now I'm pretty good at getting back to a clean install. How would I then get all the fast forms I've created (and all the other formatting) and the data as well? Is all of this inside the nubuilder4.sql file, which is located at c:/xampp/htdocs/nubuilder4/nubuilder4.sql?

From my reading, it seems I could:
1. log in to mysql at the command line
2. CREATE a database named nubuilder4
(then go to c: prompt)
3. mysql -u root -p nubuilder4 < nubuilder4.sql
4. then restart everything

Am I at all close? I believe the error is that it was copying it to the mysql folder instead of the htdocs/nubuilder4 folder (where I assume it needs to be)

Thanks again all!

[kev1n]

So, now I'm pretty good at getting back to a clean install. How would I then get all the fast forms I've created (and all the other formatting) and the data as well?!

Just do what I wrote above. Then you won't lose the forms you created.

Is all of this inside the nubuilder4.sql file, which is located at c:/xampp/htdocs/nubuilder4/nubuilder4.sql?

The forms you've created are not inside the nubuilder4.sql file. The configuration is stored solely in the database tables.

[orangezero]

So, now I'm pretty good at getting back to a clean install. How would I then get all the fast forms I've created (and all the other formatting) and the data as well?!

Just do what I wrote above. Then you won't lose the forms you created.

My issue is that I just backed up the nubuilder4 folder onto a flash drive, and then wanted to start from a fresh install of nubuilder4 onto a new computer. Figured I definitely need to learn the proper way to do this to make backups AND be able to get them working again. So, I totally agree your way is the way to go normally.

I hate to bother you all with, I believe, rather basic questions about maintaining a database. I definitely need to be doing more phpmysql and mysql tutorials for dummies Today I was hoping to get what I've done onto another computer to show some workers. The office I'm in has still been using white/yellow/pink paper copies to make invoices and it is driving me a bit nutty with the extra work it is causing.

So to be specific:

Are all the fast forms and formatting, as well as the database itself stored entirely within the www/htdocs/nubuilder4 folder? Or is it literally all stored within the nubuilder4.sql database completely and everything else I'd set up during the new install (on a new pc)? Is there a link to a procedure to backup and restore a database within nubuilder, or did I miss it in the pdf guide?

Thanks again.

My goal is to learn a lot more about this and then to help out a bit by making a few videos for youtube, maybe for my workers, but obviously to help everyone.

[kev1n]

All forms/objects etc. you've created are stored solely in the database tables and not in nubuilder4.sql.
nubuilder4.sql just contains the initial db definitions/data.

[orangezero]

Ok, so where are they stored? What all is needed? The entire nubuilder4 folder? Or is there data elsewhere?

Thanks

[kev1n]

Ok, so where are they stored? What all is needed? The entire nubuilder4 folder? Or is there data elsewhere?
Thanks

- To do a fresh instal, download the nuBuilder 4 files from either Github or Sourceforge.
- Uppack the files into a directory on your server.
- Create a new db in phpMyAdmin, e.g. nubuilder4
- Import your backup (if there is any) into the database (Because your forms are stored there, and only there !)
- Run the "Update" button within nuBuilder