Trying to figure out the easiest way to complete this without it causing me too much stress or time, ha!
Is there a recommend 'simple' way to setup new DA servers across? Same software stacks, same settings, etc. I don't want to have to go into CustomBuild if I don't have to and check one by...
Tried CloudLinux, AlmaLinux 8.x and Debian 12. All give the same error when trying to enable PHP multi-choice versions 7.4 or 8.0. I have older DirectAdmin servers running CloudLinux without this being an issue, but would like newer deployments to have the latest OS.
While 8.x support is great...
Sure, in your example above:
mysql -uUSERNAME -p DATABASENAME < /path/to/the/backup.sq
That would result in an error for me. ( ERROR 1044 (42000) at line 18: Access denied for user 'username'@'localhost' to database 'databasename' )
However, I can open the MySQL/MariaDB CLI prompt by instead...
Importing now via CLI.
Using the 'source' command after logging into MariaDB CLI.
Seems to be working.... Will report back.
What a wonky setup. I've never had to do this before. Not sure if this is a DirectAdmin thing, a Debian 12 thing, or something in between.
The original did, was long/secure. I dumbed it down and the issue persists. We responded near the same time, so perhaps my last response wasn't seen. I can access the MariaDB via SSH with the same password. It's only when I try to import the DB that it gives me a credential error.
From SSH I can:
mysql -u username_database -p username_database
And that works just fine.
MariaDB [username_database]>
But if I run the same command with "< /home/username/staging/mydatabase.sql" at the end, using the same password, I get a credential error... So strange.
I'll try shortly and will let you know. Right now I'm signed into server.com/phpmyadmin as da_admin and am trying to import the data to the "username_database" database right now.
I don't want to interupt this process as I'm already well over my allotted timeframe for maintenance on this and am...
The database has been created in DirectAdmin as a user.
Database name: username_database
Username: username_database
Password: example123
(The above info is just an example)
Via SSH, as ROOT, I run:
mysql -u username_database -p username_database < /home/username/staging/mydatabase.sql...
A customer is trying to get a .csv file to appear within the browser as opposed to automatically downloading.
Webserver: Apache + Nginx
How to proceed with this? Is this something that needs to go in a .htaccess file or what?
Hello,
A VPS with DA installed will needs to be migrated to a new IP / subnet. What would be the easiest / safest way to complete this task?
Aside from things like DNS records needing to be updated from the old IP to the new IP, what else needs to be done? Any useful scripts to cater to this...
Thanks for the feedback everyone.
We use 'proper' DNS clustering for other products, but was unaware that DA allows for what appears to be a seamless setup of multiple master DNS servers. Since DNS is (soon to be 'was') being served from each individual shared hosting server, there was no...