Hi to all! I'm fairly new to using High availability group and i've been having issues with storage space from my Logs drive from my primary server.. I just want to know why is my Log file not shrinking after I do backups(Full) on the primary server.. also, another question.. can I do the backup on my secondary server before shrinking my Logs on the primary? the reason I want to do this because my primary server has a database primarily used for Production(MES) and I don't want any downtime on their part.. Thanks in Advance.

Member Avatar
Member Avatar
+0 forum 4

Hello i have a project that uses firebase but i want to make connect to my MySql database on xampp. Any idea what to do?

Member Avatar
Member Avatar
+0 forum 1

I have been cracking my head on this mater in the past couple of days. I am faced with a situaton where i need to write a MySQL equivalent of PHP code to loop through sql select results. The Php code looks like this $query = "SELECT pubid, author FROM refs"; $sql=$con->prepare($query); $sql->execute(); $sql->setFetchMode(PDO::FETCH_ASSOC); while ($row=$sql->fetch()){ $id= $row['pubid']; $author = $row['author']; $name = explode('., ', $author); } How can one write sql/mysql query that does the same?

Member Avatar
Member Avatar
+0 forum 6

Greetings! I got a mysql database "backup" that someone made and I have to use it, trying to get a website back online. Its a Joomla web database. The person gave me a file "database.txt" (not database.sql) which opens with Notepad. Trying to "import" in phpmyadmin does not work and just gives out errors like " * Ending quote ' was expected. (near "" at position 4438), and " 42 values were expected, but found 21. (near "(" at position 3967)* I'm attaching 2 screeshots here so that you guys can see the contents of this file,somewhere it says mysql …

Member Avatar
Member Avatar
+0 forum 2

Dear All! I want to introduce a useful tool for PostgreSQL, called dbForge Studio for PostgreSQL. The main idea behind this tool is to create, develop, and execute queries, edit and adjust the code to your requirements in a convenient and user-friendly interface. Take a look at its project page: https://www.devart.com/dbforge/postgresql/studio/ If you have enough free time to download and use it, tell me what you think. Thanks for reading this, Jordan Sanders

Member Avatar
Member Avatar
+1 forum 1

I was attempting to store chat logs in a MySQL database where the message field is utf8_general_ci However, when it came across an emoji, it would choke, and the message field would only include text up to the emoji character. I changed the message field to be utf8mb4_general_ci, which seemed to be suggested upon googling, and now emoji characters are replaced in the database with four question mark characters, instead of choking. What is the best way to encode/decode emoji characters so that they can be accurately represented? (Ideally with PHP)

Member Avatar
Member Avatar
+0 forum 6

Hi Please why I got this error(SQL Error: ORA-00907: missing right parenthesis) whats wrong in my code? CREATE TABLE artphoto( photonr NUMBER(10), artnr NUMBER(10) NOT NULL, filtyp VARCHAR2(5) NOT NULL, path VARCHAR2(100) NOT NULL, CONSTRAINT artphoto_photonr_pk PRIMARY KEY(photonr), CONSTRAINT artphoto_artnr_fk FOREIGEN KEY(artnr), REFERENCES art(artnr), CONSTRAINT artphoto_filtyp_ck CHECK(filtyp in ('gif','jpg')) ); Error starting at line 1 in command: CREATE TABLE artphoto( photonr NUMBER(10), artnr NUMBER(10) NOT NULL, filtyp VARCHAR2(3) NOT NULL, path VARCHAR2(200) NOT NULL, CONSTRAINT artphoto_photonr_pk PRIMARY KEY(photonr), CONSTRAINT artphoto_artnr_fk FOREIGEN KEY(artnr), REFERENCES art(artnr), CONSTRAINT artphoto_filtyp_ck CHECK(filtyp in ('gif','jpg')) ) Error at Command Line:8 Column:44 Error report: SQL Error: ORA-00907: …

Member Avatar
Member Avatar
+0 forum 9

Hi everyone, I have database which has data of past 2 years. I want to get that data for current financial year. [COLOR="Green"](Here financial year is 1st april to 31st of March)[/COLOR] This query returns data for current calender year i.e. [Jan-to-Dec] [COde=sql] SELECT DATENAME(MONTH, DATE) AS MonthName, SUM(NetAMOUNT) AS dsfd from SALESMASTER GROUP BY DATEPART(MONTH, DATE), DATENAME(MONTH, DATE) ORDER BY DATEPART(MONTH, DATE)[/COde] I want to see the same data in the form of financial year i.e. [April-to-March] just take care financial year involves 9 months of previous year and 3 months of current year. please reply..

Member Avatar
Member Avatar
+0 forum 4

Hello ! I'm having a university project where I have to make a database on MS Access . The subject is : We have a company that deals with trading. You need to make a database to serve cost and product discounts for customers. The database must contain : -Nomenclature of customers with fields of your choice -Nomenclature of items with fields of your choice -Nomenclature, which represents individual prices for certain items pertaining to specific customers. When selecting a customer, the database must show all items with the respective prices depending on whether a customer is using it individual …

Member Avatar
Member Avatar
+0 forum 4

I got a syntax error flag in my "users" database table, but can't figure the issue out. Please, I need your help. The following is the error message: Error SQL query: --------------------------------------------------------- -- -- -- Table structure for table `users` -- CREATE TABLE IF NOT EXISTS `users` ( `user_id` INT( 10 ) UNSIGNED NOT NULL AUTO_INCREMENT , `username` VARCHAR( 255 ) COLLATE utf8_unicode_ci NOT NULL , `firstname` VARCHAR( 32 ) COLLATE utf8_unicode_ci NOT NULL , `lastname` VARCHAR( 32 ) COLLATE utf8_unicode_ci NOT NULL , `email` VARCHAR( 255 ) COLLATE utf8_unicode_ci NOT NULL , `phone` VARCHAR( 30 ) COLLATE utf8_unicode_ci NOT …

Member Avatar
Member Avatar
+0 forum 2

I'm not sure if this is the right forum to ask this in, sorry if it isn't. It's been a while since I've been to this site. We have a MS SQL database that contains a table with some columns that are no longer used (or shouldn't be). The data isn't updated anymore and has been moved to different columns to extend functionality with the applications that access the data. Anyway, I would like to remove the columns, but I need to make sure that the ASP.NET website, an Access database and a C# WinForms application don't have any code …

Member Avatar
Member Avatar
+0 forum 4

The second annual Imperva Hacker Intelligence Initiative report, this one entitled [Monitoring Hacker Forums](http://www.imperva.com/docs/HII_Monitoring_Hacker_Forums_2012.pdf), is out and reveals that the threat surfaces being discussed by the hacker community are very different from those that businesses are spending money on defending against attack. ![dweb-hackers](/attachments/small/0/dweb-hackers.jpg "align-right") The Imperva research analysed the content of a number of online hacker communities, including many lesser known forums in order to get a more accurate snapshot of what those doing the hacking are actually discussing. By looking at a total of more than 400,000 different conversational threads, Imperva was able to determine that SQL injection and …

Member Avatar
Member Avatar
+0 forum 2

We have built a software web-portal (POS system) in PHP language. Which is working fine when online. But when the internet goes down in the stores, the software stops completely and the managers are not able to make bills till the time internet is live again! Hence we want to build an offline module, which involves local server setup (wamp or easy-PHP)and deploying the code offline on the local machine/PC The problem we are facing is syncing the offline and online MySQL databases. Moreover, there are 6 different stores which will be running the offline billing module hence the problem …

Member Avatar
Member Avatar
+1 forum 2

Is the method in MySQL to set in SQL script dynamic log file name? e.g in Oracle PL/SQL set define on column sdate new_value sdate select to_char(sysdate,'YYYY.MM.DD_HH.MI') sdate from dual; spool 'logs/install_&sdate..log'; e.g. in PG/SQL \o ./logs/install_`date +"%Y-%m-%d_%H%M"`.log but I cant find similar in MySQL \T ??????

Member Avatar
Member Avatar
+0 forum 6

I've been reseraching the best way(s) to store both ipv4 & ipv6 ip addresses. Simply put, so far there seems to be much debate as to how to do so properly ranging from storing them as varchar or in a binary format. I'm really not sure at this point. I suppose I would like to hear from some folks here as to your experience doing so. Some things I need to consider: 1. At some point, I may be storing possibly millions of ips, so I do need to consider storage size in advance, obviously. 2. I also assume when …

Member Avatar
Member Avatar
+0 forum 5

The End.