Questions tagged [sql]
The sql tag has no usage guidance.
28
questions
4
votes
2
answers
86
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
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
3
votes
2
answers
104
views
Easy way to determine if a client's web host supports/allows creating SQL databases?
This is a very particular question, but I'm working on establishing a criteria at my company for when we bring new web clients aboard. Our sales team is looking for an effective way to determine ...
- 31
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
2
votes
1
answer
74
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
2
votes
1
answer
495
views
Publishing an asp.net mvc3 website database and all to a website?
Just wondering is this possible : I have some local databases which run fine. If I could move them all up to a server online it would be great (with their data and all that).
Currently, what I'm ...
- 165
2
votes
3
answers
972
views
Hosting solutions for 10,000 daily users, asp .net 4, sql server 2008 R2? [duplicate]
Possible Duplicate:
How to find web hosting that meets my requirements?
I've run a custom built social network on top of asp .net mvc & sql server 2005 for the last 2 years on discountasp ....
- 121
2
votes
0
answers
522
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 (...
- 797
1
vote
2
answers
3k
views
Does google app engine support ASP.NET
Can I migrate my ASP.NET application to Google App Engine and it will run?
Here is link, what is google app engine. As far documentation it supports either
Go Environment
Java Runtime
Python Runtime
...
- 552
1
vote
1
answer
501
views
What database engine should I use? [closed]
I don't know if this is the right place to ask this question but I want to become a web programmer for my occupation very soon. I actually went to a store known a PC WORLD in the UK where my laptop ...
- 111
1
vote
1
answer
243
views
Looking for recommendations for a server-side newsletter program
I'm currently using a server-side SQL based mailing list program called Php-List on multiple sites and it works fairly well. But installation and setup is quite cumbersome, quirky and the interface ...
- 160
1
vote
1
answer
251
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
1
vote
4
answers
9k
views
MySQL Online Database
Can anyone suggest a good online free MySQL database. I've tried four till now:
db4free FreeMySQL onPhP 000webhost
Either of them gave me an timeout error on my connect file or actively restricted ...
- 43
1
vote
1
answer
60
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
70
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
1
vote
1
answer
160
views
Service that will help me visualize SQL db
I have a website that I've built and it uses a SQL DB.
I want to be able to view that data, nicely graphed but with the relations made, so that I can keep track of trends over time.
For example I ...
- 13
1
vote
1
answer
2k
views
PrestaShop install SQL error
I am trying to install PrestaShop 1.4.0.17, and reach Step 3.
I enter database information, which tests okay, and I choose the second option:
Full mode: includes 100+ additional modules and demo ...
- 1,456
1
vote
0
answers
34
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\...
1
vote
0
answers
11
views
Storing session data between servers (and noob guidance) [closed]
First post here, I'm sure this information is somewhere on the web, but the problem is I'm such a noob I don't know what to search for.
So, my problem is that I want to design a sign up API. Let's ...
- 111
1
vote
0
answers
38
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
1
vote
1
answer
1k
views
Authenticate phpBB using custom MS-SQL database
How can I let my users to log into a phpBB forum by entering their user credentials while these credentials are stored in a separate MS SQL database?
I mean I need to customize the authentication ...
- 153
1
vote
1
answer
1k
views
Saving Image Path in SQL server [closed]
I want to know a proper way of saving image path to SQL server when working with ASP.net.
I'm using SQL server 2005 & VB 2008.
- 11
1
vote
1
answer
749
views
MySQL, SQLServer, Oracle, Postgree, CouchDB, MongoDB, Cassandra or SQLite? [closed]
Who database engine is better, in performance and usability?
- 111
0
votes
3
answers
518
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
2
answers
517
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
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 ...
- 157
0
votes
1
answer
864
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
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