6
votes
Accepted
Why can't update.php connect to my database when my site connects to it just fine?
I seem to have resolved this by explicitly adding the socket to the $wgDBserver variable in LocalSettings.php. To get the socket path, I ran this query in my SQL database manager:
show variables like '...
- 231
5
votes
How do I access MySQL console on wampserver 3?
In WAMPServer 3, it is in the same place it has always been.
You left click the wampmanager icon in the system tray and you will see this menu appear
Just like before its called MySQL console
- 151
4
votes
Accepted
Google Analytics not same with my database records
There are a number of reasons why Google Analytics may not be showing the traffic your database shows...
Your Code Is Positioned Poorly
Your GA tracking code should be in the head section of the ...
- 10.2k
4
votes
Accepted
How to export query result in a csv file from phpmyadmin
Previously answered correctly here:
https://serverfault.com/a/435443
The answer:
Execute your sql query in the SQL tab of phpMyAdmin.
After execution, scroll down the page and look for “Query ...
- 156
4
votes
Can I develop and test WordPress and PHP without a domain name?
This is quite doable. XAMPP should work fine for this. The biggest gotchas will be converting any code that does not use relative addressing to work with a domain and HTTPS.
You can likely get closer ...
- 7,640
3
votes
Accepted
How to create user in phpmyadmin to connect two servers?
Create the remote connection
To create a remote connection:
On your database server, as a user with root privileges, open your MySQL configuration file.
To locate it, enter the following command:
...
- 220
3
votes
What is the best way to exclude bots from view counts?
My approach involves two passes:
Filter only web browsers and consoles by matching the start of the user agent string with Mozilla|Opera|PSP|Bunjalloo|wii. Thanks to the user agent spoofing this ...
- 31
3
votes
Accepted
Is it unusual for a hosting company to refuse to update php and mysql?
I have been working for a hosting company and I must say, yes it is pretty normal for small and middle sized hosters and usually has good reasons. If you choose a cheap webspace plan, your site is ...
- 146
2
votes
Possible to make virtual servers on hosted web server?
So I have many sleeping databases which may use RAM memory
What you are calling "sleeping" databases -- databases you are not accessing -- do not consume any meaningful resources on a MySQL server ...
- 911
2
votes
How much diskspace does a database take?
It's all about the amount of text content. Your description isn't suffice to say how much you need, but I'm willing to guess that 1GB is plenty. Images and script and such are not stored in a database....
- 6,836
2
votes
How to create separate users in phpmyadmin, each one can't see others databases?
When you login to phpMyAdmin as the root user you are able to view ALL the databases and perform operations on any of them.
If you want to limit access to only a specific user:
Create a user for the ...
- 121
2
votes
What is the best way to exclude bots from view counts?
You can use an image as a counter, in this case it won't count bots
and page name is passed as a query with image name
I'm using this at img.php which update page view in database:
<?php
$xnt = $...
- 121
2
votes
How do I access MySQL console on wampserver 3?
If you want to access the MySQL console for Wampserver...
Run cmd command
Type c: or d: on command prompt. This will depend on where your wampserver is installed.
Assuming you have installed wamp on ...
- 10.2k
2
votes
Enable remote access to MySQL server (Linux)
You should only allow a static remote IP access to your local MySQL server, since enabling all IP addresses is a security hazard. Use the guide below as a reference for the procedure that you need to ...
- 32.9k
2
votes
Accepted
Using mySql database data directly into generating articles for my website? (newbie, needs to know where to start))
You are looking for two different solutions. Generating the articles from MySQL requires backend code like Java or PHP, along with the database MySQL. The sorting requires frontend code like ...
- 126
2
votes
MediaWiki setup is unable to log into root@localhost DB, but I can log into it via SSH
For newer mediawiki versions, there are some pitfalls that breaks the mysql connection. Some attempts to fix are:
Insert the port number on Database Host:
$wgDBserver = "localhost:3306";
On some ...
- 121
2
votes
Hosting SQL on localhost or remote server?
I think the answer depends on your goals and priorities.
If you are planning on having very large deployments, or need a system with multiple frontends having the database on a separate server allows ...
- 7,640
2
votes
Can I develop and test WordPress and PHP without a domain name?
Absolutely. For doing everything on your computer (or locally), I recommend Local by Flywheel. While the other answers (XAMPP, Docker) work great, I think Local by Flywheel greatly simplifies the ...
- 21
2
votes
Can I develop and test WordPress and PHP without a domain name?
It is quite trivial do do so. The simplest way is just to pretend you have a domain by adding it to your internal network. If you only develop on one computer, then just change the hosts (/etc/hosts ...
- 6,007
1
vote
Creating a board with thousands of forums
With modern forum software, is having many thousands of forums like this (using one copy of the forum software package for all forums) impractical for technical reasons?
Part of the answer is ...
- 13.6k
1
vote
Accepted
Where can I find User/pass for SQL in PrestaShop website filesystem?
Prestashop has pretty good online documentation and below is a snippet taken from the documentation for version 1.6 and I'm sure that nothing major has changed since 1.6 > 1.7 regarding the database ...
- 32.9k
1
vote
Accepted
Capturing a variable from a clicked link or url using php
You need to learn about GET and POST variables.
This is really basic PHP stuff :P
Have a look at http://php.net/manual/en/reserved.variables.post.php
This question is likely to be migrated to ...
- 8,418
1
vote
Manually insert text into existing MediaWiki table row?
As you see MediaWiki does not store the page content within table page, only the details of the page exist within that table. You need to locate the table 'text' and find the relevant row, thn use ...
- 32.9k
1
vote
Character set 'utf-8' is not a compiled character set and is not specified in the '/usr/share/mysql/charsets/Index.xml' file
In my case It was the same command but I did not need to change the conf file, and the command --default-character-set indeed does work. It is a bug with MySQL, just change "utf-8" to "utf8" or even "...
- 11
1
vote
Character set 'utf-8' is not a compiled character set and is not specified in the '/usr/share/mysql/charsets/Index.xml' file
I had the same problem:
ERROR: Unable to start MySQL server:
mysqld: Character set 'UTF-8' is not a compiled character set and is not specified in the '/usr/share/mysql/charsets/Index.xml' file
...
- 11
1
vote
What are the options to gradually upgrade from shared hosting if the traffic to my site grows?
It would greatly depend on how much more traffic we're talking. I'm afraid this question invites "opinions", but I'll give some perspective. I'll try to avoid reviewing hosts as much as I'd like to ...
- 797
1
vote
How do I replace a MySQL Database?
There is an alternative way to export and import the database if you have terminal access to the server.
Export the file via terminal
Execute the following command replacing the MySQL username, ...
- 168
1
vote
How do I replace a MySQL Database?
Yes you can. You just export your database as sql file and import it via phpmyadmin.
Export:
Import:
Note that if you have a very large sql file your host might not let you upload it via this ...
- 3,658
1
vote
How to analyse website performance
Expanding Marco's answer, try the browser first. Chrome, Brave and Firefox (and probably most others) have it built in and it is free.
Do a right click and select the Inspect option [Ctrl] [Shift] [...
- 2,231
1
vote
How to analyse website performance
You can also use Apache Benchmark, but 3 seconds on request tells me that you should debug your code and look for programming errors. Check php logs for clues. If you are using mySql maybe you have ...
- 111
Only top scored, non community-wiki answers of a minimum length are eligible