Webmasters Stack Exchange
Webmasters Stack Exchange

Questions tagged [sql]

27 questions
4
votes
2 answers

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 well I want to migrate now.. but I don't have…
Teddy
  • 43
  • 3
3
votes
1 answer

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? MediaWiki pages are in wiki_page and wiki_text inside…
Pitone
  • 31
  • 3
3
votes
2 answers

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 whether or not we can install certain software on a…
dmschulman
  • 31
  • 1
2
votes
0 answers

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. abc.com/my-post), when I run Xenu's Link…
Tony DiNitto
  • 797
  • 1
  • 5
  • 18
2
votes
3 answers

Hosting solutions for 10,000 daily users, asp .net 4, sql server 2008 R2?

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 .net I've been satisfied with the value as it's cost me…
Jonathon Kresner
  • 121
  • 1
2
votes
2 answers

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 move my Piwik data. So far I have installed a new…
jonboy
  • 342
  • 1
  • 11
2
votes
1 answer

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 doing is creating the datbaases remotely and creating…
meds
  • 165
  • 5
2
votes
1 answer

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 hosted on GoDaddy and works fine. I had a developer…
J Bree
  • 21
  • 1
1
vote
0 answers

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 about random completely unrelated topics, etc. I…
Vecta
  • 369
  • 1
  • 5
1
vote
1 answer

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 is not well organized... neither is the code...…
Sparky
  • 160
  • 11
1
vote
1 answer

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 server log grouping feature that let me build my…
cesko80
  • 41
  • 1
1
vote
1 answer

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)
uthanc
  • 11
  • 1
1
vote
1 answer

get mysql_real_escape is giving me errors when I try and add security to my website

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 = mysql_real_escape_string($style); $userID =…
Mike
  • 111
  • 3
1
vote
1 answer

What database engine should I use?

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 wasn't working. Anyway the person on the counter…
user1384419
  • 111
  • 3
1
vote
4 answers

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 connection to it, meaning the host won't allow a…
Marian
  • 43
  • 2
  • 4
1
2