Search Results

Search found 30858 results on 1235 pages for 'database tuning'.

Page 353/1235 | < Previous Page | 349 350 351 352 353 354 355 356 357 358 359 360  | Next Page >

• How do I quickly rename a mysql database (change schema name)?

  - by deadprogrammer

  Usually I just dump the database and reimport it with a new name. This is not an option for very big databases. Apparently RENAME {DATABASE | SCHEMA} db_name TO new_db_name; does bad things, exist only in a handful of versions, and is a bad idea overall. Oh, one more thing - this needs to work with InnoDB, which stores things very differently than MyISAM.

  Read the article

• How to read data from SQL database and store it into an XML file ?

  - by Morano88

  I have a Silverlight application that reads its content from an XML file. User can enter data and It'll be stored in SQL database. How can I read the data from SQL database and store it into an XML file ? Thanks,

  Read the article

• Reliable Way To Transfer A MySQL Database From My LocalHost To A Hosted Server?

  - by Joshua

  I've just developed a large database, and am trying to put it online. I want to make sure that all the foreign keys, defaults, constraints, views etc, are preserved. When I try to export from my development PC using phpMyAdmin and then import on my hosted server, it errors out on all the views. Is there any other way to clone a database?

  Read the article

• How can I split mySQL query logs by database?

  - by barnaby

  I've been trying to implement a mySQL Proxy solution that can separate out the queries into per-database logs. Everything I've Googled has pointed to mySQL Proxy but I can only seem to capture the database a connection was opened to, not which the current query is being issued against. Is it even possible? Is there a different tool to use? Thanks for any suggestions.

  Read the article

• How can I replicate an Oracle 11g database(data+structure) on my local machine for development?

  - by bron

  I am working on a test server with an Oracle 11g installed. I was wondering if there is anyway I can replicate the database(environment + data) on my local Linux machine. I am using a CentOS 5.3 on Windows XP with SUN Virtual Box. On Windows I am using sqldeveloper client to connect to the 11g database.

  Read the article

• Good test database on Windows to play around with data retrieval operations in SQL?

  - by ovr

  I need a test database to practice joins and other kinds of data retrieval operations in SQL. What's a good free test database and RDBMS system to use on Windows?

  Read the article

• Why is it necessary to remove and then re-add a user to a SQL Server database after restoring it fro

  - by Craig Johnston

  Why is it necessary to remove and then re-add a user to a SQL Server database after restoring it from a file? If I don't do this, I get a "User login failed" when trying to access the database using this username from apps.

  Read the article

• Faster way to know the total number of rows in MySQL database?

  - by Starx

  If I need to know the total number of rows in a table of database I do something like this: $query = "SELECT * FROM tablename WHERE link='1';"; $result = mysql_query($query); $rows = mysql_fetch_array($result); $count = count($rows); So you see the total number of data is recovered scanning through the entire database. Is there a better way?

  Read the article

• setting the datetime in jquery datetime picker with database datetime.

  - by sagar

  hi,i am developing a multi language site.My problem is i need to set the date and time in the datepicker from the database as the user may have choose the different timezone while registering in the site.At present i am getting the server time on my jquery datepicker. Thanks in advance. Technology used:Asp.net mvc,Jquery. Database:Sql server2005. O/s :winxp.

  Read the article

• How does one concatenate database values into a string?

  - by ggg

  I would like to string together database values into a string. Something like $a "text" $b. And then use the entire string as a variable, let's say $c. Is it better to do this at the database level? Will php use lots of resources to do this?

  Read the article

• How do I specify a recovery model (full, simple or bulk-logged) when creating a database in T-SQL co

  - by Ivan

  How do I specify a recovery model (full, simple or bulk-logged) when creating a database in a CREATE DATABASE query in T-SQL code?

  Read the article

• Where is the html5 local database located on a client machine?

  - by gath

  Am playing around with html5 local storage on different browsers (Firefox, Opera, Safari & Chrome) and am just wondering where is the location for the local database that i create using "opendatabase". Can i change the location of this database? Gath

  Read the article

• How are lookup columns for lists maintained in Sharepoint Content database?

  - by Abhishek Rao

  Can someone explain how are lookup columns for lists maintained in Sharepoint Content database? How is the relationship maintained in the database?

  Read the article

• how to write the array into the sqlite database for objective-c ?

  - by uttam

  i have taken the data from databse into array now i want it to send it back into database by using the insert query. how can i insert the array of the data into the database.

  Read the article

• one or more Entity models for one database for entity framework?

  - by KentZhou

  When use entity framework for DAL tier, VS 2010 can create edmx for each database. Question: If I have a database with many tables, should I create only one edmx for all tables or mutiple edmx files? for example, maybe all security tables for one edmx file, other tables for another edmx file. If there is more than one, then in other tiers, there will have more then on ObjectContext in code for business logic. Which one it the best solution for this case?

  Read the article

• In Asp.net (c#) ,how to store an image in database(linq to sql) ?

  - by Anand

  i need to get an image from client and displayed(preview) before saving it into database..and then should be saved in database after getting preview..? Is is possible in Asp.net using c#... ?

  Read the article

• Faster way to know the tolal number of rows in Mysql Database?

  - by Starx

  If I need to know the total number of rows in a table of database I do something like $query = "SELECT * FROM tablename WHERE link='1';"; $result = mysql_query($query); $rows = mysql_fetch_array($result); $count = count($rows); So you see the total number of data is recovered scanning through entire database Is there a better way

  Read the article

• ADO.net - how do I reload database data into an existing & filled DataTable?

  - by Greg

  Hi, If I have an existing DataTable (already filled) but then I want to refresh/reload the data from the database directly (as I know there was a non-ADO.net process that changed data without going through the DataTable), however do I do this "refresh". Note the database data at that point can overwrite whatever is in the DataTable. thanks

  Read the article

• Is there a way to listen for changes in an MySQL database table using Java and JDBC?

  - by adrian7

  I have a number of users which are logged in at a time in my desktop application. They are working on the same table (create, read, update, delete data) so I have to update their views, to reflect changes, every few seconds - currently I am thinking to use a different thread to do that. I am using the MySQL database engine. Is there a way, using JDBC, to listen for changes on a specific table in the database and triggering a Java method only when changes are made?

  Read the article

• Is SQLlite strong enough to use as wordpress database ?

  - by justjoe

  i'm just curious. so i ask this particular question about SQLite. I haven't use this type of database extensively. but care to explain what is the basic different between SQLite and Mysql ? The reason behind all of this is i just want to know whether it possible to use it to store wordpress data and act as a database ?

  Read the article

• What is best way of keeping two database schema in synch?

  - by ebeworld

  We have two SQL server database, and one is kept in US and being changed from day to day and the other one is in India. What is the best way of keeping two database schema in synch. Does any functionality like sql server replication help?

  Read the article

• Best way to store a database password in a startup script / config file?

  - by Mark Harrison

  So our web server apps need to connect to the database, and some other apps have startup scripts that execute at boot time. What's the best way to store the name/password for these applications, in terms of security, e.g. perhaps we don't want sysadmins to know the database password maintainability, e.g. making the configuration easy to change when the password changes, etc. both windows and linux solutions appreciated!

  Read the article

• I have a problem saving foriegn text to a SQL Server database table with a nvarchar field.

  - by user307840

  I have a requirement to have a multiline textbox that accepts any text from any language and stores this into the database for later use. I am using Linq with ASP .NET 3.5 with a SQL Server 2005 database. Any/all information you can provide me with is much appreciated :D

  Read the article

• How Can I Delete The Contents Of All Tables In My Database In phpMyAdmin Without Dropping The Databa

  - by Joshua

  How Can I Empty The Contents Of All Tables In My Database In phpMyAdmin Without Dropping Any Of The Tables In The Database? Since I Do This Several Times An Hour While In Development, I'd Rather Not Individually Click "Empty" On All 60+ Tables Every Time. Thanks In Advance.

  Read the article

• How to update database when using wild characters for example like .

  - by SmartDev

  Hi , I have column which consists of path for example \Abc\F\E\record_123 , now i need to update the path in database where only one change i need to do is tht \Abc\F\E\record_123 = \Abc\F\G\record_123 - i want to update E to G . how to do that with update query in database . Can anyone help me its urgent. Thanks Smartdev

  Read the article

< Previous Page | 349 350 351 352 353 354 355 356 357 358 359 360  | Next Page >