Questions tagged [sql]
The sql tag has no summary.
27 questions
2
votes
1
answer
141
views
How can I copy a website from GoDaddy cPanel to my Mac
I want to move a small working website to my Mac for testing and experimenting. There is a small database with the website that will need to be accessed locally as well. The website is currently ...
- 21
1
vote
0
answers
40
views
Why does Dreamweaver save the same .php file twice?
I am creating a website on localhost (WAMP) as of now.
I have set up the testing server
the new php files that I create are saved in a sub-foldor of www
folder specific for my website. [ C:\wamp64\...
2
votes
0
answers
565
views
Using Xenu's Link Sleuth to remove bad 301's / broken page-local links
I'm trying to fix 2 issues based on the report from Xenu's Link Sleuth.
I have numerous 301 Redirects from Wordpress SQL based URLs despite using post name URLs.
Despite using post name based URLs (ie....
- 807
1
vote
0
answers
45
views
PHPBB Post Export Contains Unexpected Results
I am working on migrating a PHPBB forum for a client and have exported their posts table. I looked the SQL over and there's all kinds of random stuff—posts in Swedish (it's an English site), posts ...
- 369
0
votes
3
answers
663
views
Most efficient method uploading a large SQL db (200mb) to server
Is there an easier way to upload an sql database to the server so it can be accessed via phpmyadmin?
My dev seems to do it so easily, however if i try my internet connection usually times out due to ...
0
votes
1
answer
909
views
How do I host an asp.net dll application in a WP website?
We're migrating from an ASP.NET website to a WordPress website, hosted on IIS (don't ask). There's a few things we need to migrate over, and for the most part I can get away with a simple HTTP ...
- 121
2
votes
2
answers
1k
views
Migrate Piwik Data
I currently have Piwik installed on analytics.myhost.com with lots of data. This has been live for over a year so I would like to keep all of my stats.
I have moved hosts now therefore also need to ...
- 342
3
votes
1
answer
1k
views
How can I delete all Wiki pages created by spammers except mine in MediaWiki?
I Implemented a MediaWiki site but unfortunately somebody created thousands of pages through thousand of users.
Which query could I run for deleting all pages created by these users except mine?
...
- 31
4
votes
2
answers
103
views
Slow Migration is it possible with a PHP/SQL Driven site
I have a Joomla site that is operating on www.mysite.com, I want to migrate to WordPress but heres the thing, I have hundreds of pages and simply moving migrating them to a test site isn't ideal since ...
- 43
1
vote
1
answer
67
views
Is there any profiling tool to measure web application performance by identifying common interactions paths?
I would like to measure how long it takes to complete a single operation such as "UPDATING AGE ON A CUSTOMER FORM", "INSERT A NEW CUSTOMER" in my web application. Is there any tool with some web ...
- 41
1
vote
1
answer
80
views
How to remove an old ip address from my connection script?
How can I remove the old ip address from my connection script?
Just now my site show:
Error establishing a database connection.
I am using wordpress on mixedsoft.com (remote sql issues)
- 11
0
votes
2
answers
549
views
Check/Monitor Amount of SQL Queries per Hour [closed]
My website is hosted on a shared hosting and I'd like to know how much SQL queries it is using per hour. I tried to navigate through cPanel and I find nothing to check or monitor the amount of SQL ...
- 161
1
vote
1
answer
261
views
get mysql_real_escape is giving me errors when I try and add security to my website [closed]
I tried doing this:
@ $db = new myConnectDB();
$beerName = mysql_real_escape_string($beerName);
$beerID = mysql_real_escape_string($beerID);
$brewery = mysql_real_escape_string($brewery);
$style = ...
- 111
0
votes
3
answers
2k
views
How to publish/transfer a completed website with database from one server to another server?
How to publish/transfer a completed website with database from one server to another server?
I have been creating .net website with mssql database (with an inbuilt online text editor for live editing ...
- 11
0
votes
1
answer
3k
views
Warning: mysql_fetch_array() expects parameter 1 to be resource [closed]
I was trying to connect to my database through PHP but I keep getting the error:
Warning: mysql_fetch_array() expects parameter 1 to be resource
I do not know what the problem is?
This is the code ...
- 157