If you already have a Firebird database and want to upload it to your hosting account, just follow these steps:
Step 1
1. Save/export your local database with the user that accesses your hosting.
The password must contain exactly 8 characters, you can define it through the "Firebird Databases" item, see; Here
.png)
Note: You must grant all privileges to the user before uploading it to hosting, you can use the GRANT command. For example:
.png)
Step 2
You must also adjust all database, table, view and procedure permissions.
To do this, you can use the commands below, replacing USUARIO_FIREBIRD with your Firebird hosting user.
.png)
2
.png)
3
.png)
Note: After executing each command, you must copy the displayed returns and execute them in your database.
Step 3
1. Upload your database to the hosting. You can do this through your cPanel in the File Manager item.
.png)
2. Create a folder named Firebird.
After creating or if the folder already exists, you must change the folder permissions to 777.
To do this, simply right-click on the folder and go to the "Change Permissions" option.
Now your database file is ready to be uploaded. Simply go to the Upload option at the top of your screen.
.png)
Then just drag your file and wait for the upload to complete.
.png)
4. Access the database through a database manager or application using the data:
Host/Server: The main domain of your hosting.
Path: the full path to the database location, example: /home/user/firebird/db.fdb
Port: 3050
User: cPanel user of your account
Password: password defined in the “Firebird Databases” item.
Hope this helps !