Knowledge / everything · hot matching “database”

5 shown · updated 1m ago · read only

How can I run a MySQL client through an SSH tunnel to a VPS in a single script? [closed] (stackoverflow.com)stack

23 points by hoi in stackoverflow.com · 3h ago · stack

I need to connect to a MySQL database on a remote Ubuntu VPS that only accepts local connections (bind-address 127.0.0.1). I want to open an SSH tunnel and run a query against the database from my local machine in one step, so I can automate backups. This is what I have tried so…
filed under ssh mysql-cli
Apache Camel transaction rollback not working when JMS reply queue fails (stackoverflow.com)stack

19 points by MMRahman in stackoverflow.com · 27d ago · stack

I'm using Apache Camel with ActiveMQ to process messages in a transactional route. The route receives messages from a queue, performs a database operation, and then sends a response back to a temporary/reply queue. However, when the temporary queue is unavailable or lost during…
filed under java spring-boot apache-camel activemq-classic
PostgreSQL rename table - cascade renaming to objects like indices, constraints that contain table name (stackoverflow.com)stack

12 points by Tom in stackoverflow.com · 5y ago · stack

I renamed my tables with ALTER TABLE _ RENAME TO _ : ALTER TABLE foods RENAME TO food; ALTER TABLE foods_nutrients RENAME TO food_nutrient; It worked, however other database objects like indices, sequences and constraints that contained these table names didn't update. So I had…
filed under postgresql
Fixing deprecated SimpleMongoDbFactory to SimpleMongoClientDbFactory break Embedded Mongo tests (stackoverflow.com)stack

10 points by Zejuho in stackoverflow.com · 6y ago · stack

I work on a project which was extending SimpleMongoFactory to enable multi tenancy public class MultiTenantMongoFactory extends SimpleMongoDbFactory { After migrating from Spring boot 2.1.10 to 2.2.1 , we tried to fix deprecation warning by using recommended class SimpleMongoCli…
filed under java mongodb spring-boot embedded-database
CodeIgniter view is neither showing query results, nor updating html table rows from AJAX requests (stackoverflow.com)stack

5 points by aan in stackoverflow.com · 8y ago · stack

I want to get data from database by using ajax. The data will be fetched by choosing the drop down option and click the search button and data will show up in the table. I've written the proper query and it runs very well. All I want is just show the data from database to the ta…
filed under javascript php ajax codeigniter model-view-controller