I compared the "forums which ported to categories" against "forums which did not port to discourse categories" and the forums "which did not port" all had a parentid of -1,
So, I think this can be fixed by altering the "dumped DB" and changing all forum parentid to -1.
I will do this as a part of "round 2" after this migration test is done.
Currently, I am planning a migration between machine which under True64UNIX. The new machine will run with higher version O/S. My question is, is there any solution on migrating one machine to another which with different O/S version? My goal is keeping minimum impact to the users.
Excuse my... (1 Reply)
I'm trying to see every file which my group (staff) has in a certain directory, recursively. The pipe
ls -l -R | grep staff
is not working exactly as I want, as for every directory to which my user does not have access, a line like:
ls: ./directory/lost+found: The file access permissions do not... (5 Replies)
If I have an oracle 9 database environment on a san running solaris 5.8 as the os. Can I plug the san into a Solaris 5.9 environment and have the database work ? - as long as binaries are on the san (1 Reply)
I have some UFS volumes (non root), that I would like to change into ZFS volumes.
Is this possible ?
I think the only method is to create a new zfs volume and copy the data accoss, this would take a long time for us. Is there a quicker way ?
Regards (5 Replies)
Here is the issue:
I am building a database server using Solaris 10x86 U8.
The system is jumpstarted with mpxio enabled and booting from the san.
We need to have powerpath 5.3 installed and would like to have powerpath take control of the the boot san as well or have mpxio control the san... (2 Replies)
Hi ,
I would like to (MYSQL) migrate the all the data from solari's to linux box.
I have checked whether mysql is installed or not.
rpm -qa | grep -i mysql
I confirmed !!!!
I want to know the following points.
1) How can get to know what are mysql data files and location as well.... (4 Replies)
Hi,I am using following code for FTP in shell script file and it is working.Now I want to migrate from FTP to SFTP.What code changes/steps I have to perform for SFTP ?
ftp -in <<FIN
open $SAP_UP_SERVER
user $SAP_UP_USER $SAP_UP_PASSWORD
asc
put... (7 Replies)
Discussion started by: Nitin Varshneya
7 Replies
LEARN ABOUT PHP
dbx_compare
DBX_COMPARE(3) 1 DBX_COMPARE(3)dbx_compare - Compare two rows for sorting purposesSYNOPSIS
int dbx_compare (array $row_a, array $row_b, string $column_key, [int $flags = DBX_CMP_ASC | DBX_CMP_NATIVE])
DESCRIPTION dbx_compare(3) is a helper function for dbx_sort(3) to ease the make and use of the custom sorting function.
PARAMETERS
o $row_a
- First row
o $row_b
- Second row
o $column_key
- The compared column
o $flags
- The $flags can be set to specify comparison direction:
o DBX_CMP_ASC - ascending order
o DBX_CMP_DESC - descending order
and the preferred comparison type:
o DBX_CMP_NATIVE - no type conversion
o DBX_CMP_TEXT - compare items as strings
o DBX_CMP_NUMBER - compare items numerically
One of the direction and one of the type constant can be combined with bitwise OR operator (|).
RETURN VALUES
Returns 0 if the row_a[$column_key] is equal to row_b[$column_key], and 1 or -1 if the former is greater or is smaller than the latter
one, respectively, or vice versa if the $flag is set to DBX_CMP_DESC.
EXAMPLES
Example #1
dbx_compare(3) example
<?php
function user_re_order($a, $b)
{
$rv = dbx_compare($a, $b, "parentid", DBX_CMP_DESC);
if (!$rv) {
$rv = dbx_compare($a, $b, "id", DBX_CMP_NUMBER);
}
return $rv;
}
$link = dbx_connect(DBX_ODBC, "", "db", "username", "password")
or die("Could not connect");
$result = dbx_query($link, "SELECT id, parentid, description FROM table ORDER BY id");
// data in $result is now ordered by id
dbx_sort($result, "user_re_order");
// date in $result is now ordered by parentid (descending), then by id
dbx_close($link);
?>
SEE ALSO dbx_sort(3).
PHP Documentation Group DBX_COMPARE(3)