Mass Installation
I need to install the same database on 40 accounts, all with the same database name, and same table in it... any way of doing this? I've got access to WHM.
View Complete Forum Thread with Replies
Related Forum Messages:
Mass Insertion
I have a user event manager where they would like to be able to insert recurring events. This is to say that the user specifies that an event would recur (for example) every week at the same time, and then the script would insert all these seperate events. Is there anyway to use a single query to do something that inserts a certain amount of data into the proper records and sets the dates correctly? Or do I need to recursively contruct a query to insert all the records at the code level?
View Replies !
Mass SQL DELETE
managed to get put in charge of a forum that uses it extensivly. Currently, the forum is getting bogged down by the 1.5 million posts so I have archived and wish to delete them. I have tried a lot of different variations on DELETE, all of which time out. I am left SELECTing the TOP 20000 and then highlighting and deleting them. I would like to find a quicker, more efficiant way of deleting 1 million rows from a single table (tblThread) that won't timeout.
View Replies !
Mass Inserting
I'm trying to build a query for a mass insert it is like insert into table values (, , , , , ... ,) , (, , , , , ... ,), (, , , , , ... ,), (, , , , , ... ,), (, , , , , ... ,); however, I notice I can't get more than 1000 inserts this way, what is the maximum amount of inserts I can make using this query?
View Replies !
Column Alias On Mass
Is possible to retrieve all columns and alias them all at once. Eg, normally you would write select * from products which would return id | name | price ----------------------- 1 | Test | 14.00 but I want to be able to say select p.* from products p, so that it returns the columns as such p.id | p.name | p.price Obviously I can do this manually as such select p.id, p.name, p.price from products p .... But that would take a lot of big queries as some of my tables have 50 columns.
View Replies !
Mass Updates To A Table
I've got a web-based form that will allow people to update a database that is displayed as a table. Let's say that there are several columns across titled Red, Blue, Green... and several rows titled 01, 02, 03... In each cell, they can fill in some simple text data. The only way that I can think of to update the database with this information is using two imbedded loops in Perl: pseudocode: for($color=1;$color<=10;++$color) { for($number=1;$number<=10;++$number) { update table xyz set value=$value[$color][$number] where color=$color and number=$number; This would mean that it would have to execute 100 update statements. Perhaps this is no big deal and I shouldn't worry about it, but since I'm relatively new to sql, I'm guessing that there's probably a more streamlined method to do this. BTW - I've seen a lot of people asking questions that were vaguely similar to mine in this group, and they've been told to go to the php group, even though I didn't see any php-specific code in their questions. I don't use php and don't have it installed on my server.
View Replies !
Mass Left Join
I would like to join a lot of tables but they all share the same structure. All of them have the same id column. I found a solution, but I'm almost sure there is a more efficient way. My solution is like this: select id,c1,c2,c3,c4,...,c29 from t1 left join t2 using (id) left join t3 using (id) left join t4 using (id) ...
View Replies !
Efficient Way Of Mass Indexing?
I have been working on a program that will populate and index a database. The populating doesn't take too long, but the indexing does. My question is: Is there a better approach to indexing this table than the one I'm using right now? I'm doing this through QtSql. headers is a QString array of 48 column names I want to index. for (int i = 0; i < headers.size(); ++i) { q.exec("ALTER TABLE mysqltable ADD INDEX(" + headers[i] + ");"); } example run for 20000 rows: viper,david $ time ./main -r 20000 Database Connection Established 0.520u 0.060s 0:21.27 2.7% 0+0k 0+0io 0pf+0w
View Replies !
Mass Update Tool
we have so many mass upload tools, load from the file, load from other database built in. How about mass update tools? Say I have a table have 3000 products in it. I want to update the price of these 3000 products with a new table (or excel sheet) of new price by matching the product code (key).Is there a tool for that?
View Replies !
Sending Out Mass Email
I have about 10,000 members with emails stored in a database and would like to be able to send emails out to each of them. I'm not sure at all how it would be done though. I tried a for loop using MySQL queries but none of it worked. Does anyone have any suggestions on how to do this? I would love to send out a newsletter to my users.
View Replies !
Help With Mass Update Query
I have a field in my table (1000 records) called company_number. I've just been informed that all records that start with "1" should actually start with "0". So, for a record where compnay_number = 1000400 the number should actually be 01000400. Can anyone suggest how I would approach updating each record via one SQL statement? SELECT * FROM `myTable` WHERE `company_number` LIKE '%100%' ... then what?
View Replies !
Weekly Mass Data Relocation
I've got a table located on my website and localhost. The table maintains a size of about 200MB. The table holds a running 4 weeks of data (50MB/week). I have a winapp that updates my localhost db each week and currently, I run a backup on the table using the MySql Administrator... then I run restore on my website's mysql server. This deletes the whole table and reinserts each row. This isn't needed and is a long process. Is there a way to select a range of rows from the localhost table and "migrate" those rows to my website's mysql server without following the process I just described?
View Replies !
Mass Converting Database Entries
I have an phpbb board and some old MOD changed some entries that it shouldnt. I need to change 1300 entries to default value. How can i do that without having to change one by one manually?
View Replies !
Mass Replacing Info In Tables
fairly new to mysql and wondering is there any way to mass replace info in one of my fields. I have a town based member website and they enter their town which goes into the town field of my member table. Problem is the town has officially changed it's name and I am looking for a way to just mass replace everyone's town name in the field. For example all users are from Billington and I want to mass replace every members town field with New Billington the new town name. I understand that I can open up each members profile and type in the new town but I have about 1000 members and was looking for an easier way.
View Replies !
Mass Replace Text In String
I want to replace a few letters in a string throughout my database column and using: UPDATE products SET pID = REPLACE (pID, "BSC", "BRC") Did not do the job. The Strings are variations of 33-BSCE7_14_16 all having BSC that needs to be changed to BRC Is there a way to use something like "*BSC*" to have it found and replaced?
View Replies !
Export Table Data For Mass Labels
My goal is generate large lists of mailing labels that are based on: Name Address City State Zipcode I created the table and fields, implemented a submission form, and incorporated a link for an admin to download the data into Excel but thats as far as I got. Is there a better or more thorough approach? I believe that in the end, I want to download this into Word so I can do a mail merge.
View Replies !
Want To Speed Up Mass INSERTS When There Is Processing Of The Insert_id()...
I am importing data from a large plaintext data set and it is going very slowly. I need to acquire and process the insert_id from each record so I cannot use INSERT DELAYED or LOAD DATA INFILE, for which I could speed things up by increasing the bulk_insert_buffer size. I'm not sure if there is really anything that can be done, but I thought I'd ask. The looping process is like this. 1. insert row into table 1 2. get insert id 3. one or more inserts on table 2 using the insert_id Repeat 2000 times or so per page load, because PHP just dies if the file isn't processed in small result sets. It is partly slow because table 1 has several indexes and table 2 has one. The indexes cannot just be added at the end either. In the end there will be +30million rows in table 1 and probably more than 100million in table 2 so if I tried to add the indexes at the end php would die off long before the script could complete.
View Replies !
Nothing After Installation
I need to incorporate MySQL and php into the site to accomplish what all they are wanting the site to do. But I am having a problem getting MySQL installed and running. OS: Mac OS X vs. 10.4.5 I have downloaded Mac OS X 10.4 (x86) Standard 5.0.20 and ran the pkgs but nothing seems to happen when I close out of the installer. I can't find it anywhere on my hard drive. I also have MySQL Query Browser installed but I can't do anything with it at the time being because I'm guessing my other isn't installed correctly or I just don't know what I'm doing to begin with. Probably the later.
View Replies !
Mysql 5 /msi Installation
i had mysql 5 alpha installed and npow i uninstalled due i downloaed the latest v5 .msi. Although i uninstalled the previous mysql before installing the current one, the latter wont be able to start when try to install itslef as a windows service. I have disables from administrative tools-services the previosu mysql set it to disable so now i guess the old one its not runnigns as a service but the new one wont start why?
View Replies !
Installation Query
i have installed MySQL on a new machine.. its all up running fine. Using PHP I have sent a CREATE DATABASE statement to Mysql and it has run fine. However in winMySQLadmin, it doesnt show as a database! If I run the PHP query again, it comes up "Cannot Create database; database exists".... so its there and you can select the database fine. Tried restarting mySQL, but its still not there? Can anyone explain why it wouldnt show up?
View Replies !
Mysqlserver5.0 Installation
I've installed mysqlserver 5.0(mysql command line client) on windows2000 and that looks ok. But my problem is how do i view tables e.t.c.Should i install WinMySQLaDMIN 1.4.
View Replies !
Installation On WinXP
I have installed MySql on my WindowsXP laptop, but cannot start the service. I entered the following command: net start mysql And got the following messages. The service could not be started. A system error has occurred. System error 1067 has occurred. The process terminated unexpectedly.
View Replies !
New Mysql Installation
I just installed MySQL and the appropriate ODBC driver on IIS 5, and can't make it work. The db server itself is running as a service just fine. Here's the error I get when trying to connect from a PHP script: Warning: mysql_connect(): Access denied for user 'root'@'localhost' (using password: NO) I get a similar error trying to connect from a command line. I feel sure I must have skipped some necessary step in setting this stuff up.
View Replies !
Eventum Installation
I am NOT a system administrator, so there is a bunch of this stuff I don't understand. I just need to get Eventum installed, and unfortunately the documentation is not clear enough for me. Is there an "A-B-C....etc" type of document anywhere? It's not even clear enough where to install the My-SQL portion, so I guess I'm just a real dunce. Thank anyone who responds that can help. Also, does anyone know whether this will work on an Earthlink hosted space?
View Replies !
Installation Problem
I have installed Apache Server 2.0.52 and PHP 4.3.9 on XP Pro (Service Pack 2). I downloaded MySQL 4.1 (Windows Essentials) and installed it. The MySQL server starts up fine but I can't connect to it from a web page that I design. I used a normal PHP script to display the version, etc. I also tried installing My PHP Admin but it does not connect to the Database at all. Is there a configuration that has to be done or Did I do the installation wrong? Can someone please give me advice or a run down on the installation process that I have to follow in order for it to work on my system. Code:
View Replies !
Installation Problem On Win 98
I tried to install the latest mysql on a win 98 machine which ran a previous version. There were no error messages, only the two last items on the final installtion configuration wizard were grayed out (if I am not mistaken these were about setting security features and running the server). After the installation, my Start menu included only to shortcuts: to the command-line shell and to the configuration wizard. There was no server shortcut. When I tried to run mysqld, it just closed. Then I uninstalled everything and tried to re-install the old version, which ran on this machine until a few hours ago, and it to behaved exactly the same: the server just closed when I tried to start it.
View Replies !
Installation Help For Mac OS X 10.5 Leopard
I am trying to install MySQL for my Mac running OS X 10.5 Leopard. I want to use a GUI to avoid scrambling something in Terminal, as well as it being easier on the eyes. I have downloaded the two DMG's: mysql-5.0.67-osx10.5-x86.dmg mysql-gui-tools-5.0-r12-osx10.4-universal.dmg I installed the GUI no problem, but MySQL is another thing. I have been scouring the internet for a month or so looking for a definitive way to install it, and there doesn't seem to be one. I tried following some directions a few weeks ago, but I must have messed up. Is it as easy as just installing the packages in the dmg, as well as the prefpane? Or do I need to do some Terminal work as well?
View Replies !
Installation Run With Postnuke
I wanted to ask witch version of MySQL I need to run PostNuke with on a webserver. I'm not familiar with this knowing I used a c/panel before witch allready had a MySQL database installed on it.
View Replies !
Order Of Installation
Background: The Unix server on Apache already has MySQL 3.23 and PHP 4 installed. I've never used MySQL, so there are no tables at present. Problem: I need even more basic steps to upgrade 3.23 to 4.0 than the Reference Manual gives. (I read somewhere that I cannot upgrade directly to 4.1.) I expect to use the FreeBSD 4.x (x86) version. Would the following be the steps I take in order? If not, how should the order be corrected? 1. Download the FreeBSD software to my Windows XP computer. 2. Create a /mysql4.0/ folder in the same Unix server directory as the current /mysql/ and copy the downloaded file to the newer folder. 3. Using my Putty program, do a vinstall mysql (in the newer folder) to install the newer version in this folder. Am I supposed to stop the earlier version first? If so, what command do I give for this? Once the new version is installed, may I simply do a Remove of the earlier version's folder? I think once these steps are taken, I'll be able to follow the steps in the Reference Manual.
View Replies !
Installation Of MYSQL On OS X
I installed MYSQL on my MAc -OS X 10.3.9. When I try and connect I get the following error: Welcome to Darwin! /usr/local/mysql-standard-4.1.12-apple-darwin7.9.0-powerpc/bin/mysql; exit Mist:~ jbrousseau$ /usr/local/mysql-standard-4.1.12-apple-darwin7.9.0-powerpc/bin/mysql; exit ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (61) logout [Process completed]
View Replies !
Mysql Db Installation
I installed mysql server and i dont understand what i have to do from this point in order to have mysql database. Do i need to run script for create database Code:
View Replies !
PAST INSTALLATION
I know almost nothing about MYSQL. I can programme (more or less) in Paradox. I installed MYSQL 4.1 for Windows, but there is no explanation of how to get it to run like the databases I know. (Paradox/Access). All you get is a black-screen DOS-like dialogue box which is a command-line monitor. With Paradox/Access, you get a proper inferface to play with tables, and can either programme an application or not. MYSQL seems inpenetrable without special knowledge. If MYSQL has to be programmed by a programmer before you can even learn how to use it then it's not much use to me. Am I missing something?
View Replies !
Error In Installation!
I'm trying to install Apache, MySQL and PHP on my office PC. Apache and PHP were installed successfully but when I click on the setup.exe icon of MySQL, this error comes out: C:WINDOWSSYSTEM32AUTOEXEC.NT. The system file is not suitable for running MS-DOS and Microsoft Windows applications. Choose 'Close' to terminate the application. What should I do? Is there something I should configure in the PC before I install MySQL? I'm currently using WindowsXP at my office PC. I need it for a project I might do soon for the company and I need my PC to act as an offline server.
View Replies !
LDU 801 Installation Problems
I am using the following: Apache 2.0.55 (whatever the latest version is, I believe that's it.) MySQL 5 PHP 4 LDU 801 And it gives me an error telling me to "Upgrade my MySQL client", so in other words I can't connect to my database I have designated for this site. I checked the settings and all seems normal. I can connect to the database with the MySQL command line client.
View Replies !
MYSql 5 Installation
Downloaded MySql 5 and installed OK. However when I try to set up a MySql instance, using all the defaults and InnoDB tables, the service will not start. I checked Admin->Services and the MYSQL service is there and is set to start automatically but is marked stopped. When I try to start it I get error 1067.
View Replies !
Silent Installation
I'm new in this forum. I want to Install MySQL without userinput. Can I run the setup.exe (the Setup Wizard and the Server Instance Configuration Wizard) with parameters or a script? If so, what do I have to do? If not how can I do an automatic Installation?
View Replies !
Installation Complete
I have installed mysql-5.0.19-win32 and 'services' sayes it is running. However, previous version a 'traffic light' would appear in the taskbar. So I am wondering if my installation complete because no icon appears in the taskbar.
View Replies !
PHP-BB And MYSQL? Installation?
I've got my own web server in my office which i use to run my business web site from. It already has Perl, and I installed PHP last night. I installed it because i want to make forums for my site. I'm pretty new to php, but i'm a fast learner, and decided to have a go. I also installed PHP-BB to make my forums with. The problem is, it's asking me for a database something? Now i don't know what on earth to do from here. I've tried selected all of them to see if they'd work, but they didn't. I think i need to install some kind of database thing to my server so i can set my forums up. has anyone any suggestions, and if they have, how do i go about it?
View Replies !
Help With MySQL Installation
I was wondering if any one out there could help me. I'm new at MySQL and just beginning with Kevin Yank's book. I have downloaded and installed MySQL as instructed, everything seems to run perfect until I change the password for the root user. From there on when I try to run Mysqladmin I'm requested my new password but when I enter it I get the following error message. MySQLAdmin: connect to server at local host failed. Error: 'Host 'localhost' is not allowed to conect to this MySQL server' I also tried to open mysql command line and I get this error message: error 1130 (HY000) Host 'localhost' is not allowed to connect to this MySQL server. What am I doing wrong?
View Replies !
Wordpress Installation
I was using Fantastico in Cpanel to install Wordpress. I did the first step (filled out user, password, default folder, etc.). Then, when I got to the second step where it would create the database, I stopped. Got started on something else. When I went back and tried to install it again, it gave an error. So, I deleted all of the files and folders (except for the cgi-bin folder) in the root folder and tried to install it again via Fantastico. Still get the same error. Then went into Fantasico, hit Wordpress, and removed the "unknown" installation that it had listed. Tried to install again and stil got the same error: Here's the error I'm getting: The installation can not be completed: - You cannot install more than one script in the root directory of a domain. Suggestions? I looked in MyPHPAdmin, and there is still a db in there with 10 tables, and it is definitely for the WP installation. Should I delete it? If so, how?
View Replies !
Phpmyadmin Installation
I have used phpmyadmin a good bit in the past but its always been when my hosting company has set it up for me. Today i am having to FTP upload phpmyadmin myself for the first time and i am having problems with the config.inc.php installation process. So far i have used the setup feature to create my config.inc.php file and have uploaded it to my root folder. Here's what i have uploaded: PHP Code: <?php /* * Generated configuration file * Generated by: phpMyAdmin 3.1.2 setup script by Piotr Przybylski <piotrprz@gmail.com> * Date: Fri, 06 Feb 2009 15:56:08 +0100 */ /* Servers configuration */ $i = 0; /* Server: localhost [1] */ $i++; $cfg['Servers'][$i]['verbose'] = ''; $cfg['Servers'][$i]['host'] = 'localhost'; $cfg['Servers'][$i]['port'] = ''; $cfg['Servers'][$i]['socket'] = ''; $cfg['Servers'][$i]['connect_type'] = 'tcp'; $cfg['Servers'][$i]['extension'] = 'mysqli'; $cfg['Servers'][$i]['auth_type'] = 'http'; $cfg['Servers'][$i]['user'] = 'root'; $cfg['Servers'][$i]['password'] = ''; /* End of servers configuration */ $cfg['DefaultLang'] = 'en-utf-8'; $cfg['ServerDefault'] = 1; $cfg['UploadDir'] = ''; $cfg['SaveDir'] = ''; ?> When i first tried to login i just used "root" as my login name and left the password blank. Then it brought me into phpmyadmin and i saw a link for setting your password. I tried this but got an error message so just thought it didnt do anything but now when i try to open phpmyadmin i just get a blank screen.
View Replies !
|
TRACKER
