having problems w/my remote host recognizing my classes. i've put the classes in web-inf/classes and set the web/xml to:
<servlet>
<servlet-name>ServletName</servlet-name>
<servlet-class>ServletName</servlet-class>
</servlet>
<servlet-mapping>...
having problem selecting data from from a .csv or a .txt file using dbi:file in the following:
$dbh = DBI->connect("DBI:File:f_dir=../directoryLocation") or die "Cannot connect: " . $DBI::errstr;
foreach $addedProduct (@productArray)
{
chop($addedProduct);
$item_number = $addedProduct...
laura -
i was missing the --opt command which will input the following:
DROP TABLE IF EXISTS products;
CREATE TABLE products (
...
...
)
the statement i used is:
mysqldump --opt db > backup-file.sql
lgarner -
thanks. i'll check that out.
best.
thanks for the help.
sorted out the upload issue. but now getting:
ERROR 1050 at line 1: Table 'products' already exists
i thought that a backup file will try to drop a table before the restore.
what's the gig ?
best.
laura,
thansk for your reply.
i've tried:
mysqldump -u root db > mysql -u my-username -p --host=my-site.com.com -C database-name_db
and get the following after i enter the correct p-word:
ERROR 1045: Access denied for user: 'username@my-ip-number.net' (Using password: YES)
any ideas ...
we have a master mysql db locally where we update, delete, insert, etc. we want to use the same db remotely at a handful of different sites on different hosts, etc.
questions is: is there a way that the local master db can be uploaded to 6 different servers, each time replacing, overwriting...
paul - thanks for the reply:
but:
$rowResults[$counter] = @row;
& then:
print "@rowResults<p>";
print "$rowResults[0]<p>";
print "$rowResults[1]<p>";
print "$rowResults[2]<p>";
returns:
7 7 7
7
7
7
which is the size of @row.
i'm trying to populate an array with a reference to array returned by:fetchrow_array so that I can use the values more than once during in script
$counter = 0;
foreach $addedProduct (@cartData)
{
my $query = "Select column1, column2, column3, column4, column5, column6, column7 from tableName...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.