- Written by charlie
- Category: Books & Media
Delaware's Department of Natural Resources and Environmental Control (DNREC) just released its fifth wetland related video as part of the “Wetlands 101” video series - “Restoring Wetlands: Facing Challenges” on DNREC’s YouTube Channel.
“Restoring Wetlands: Facing Challenges” focuses on common problems that wetlands face, and what Delawareans can do to help restore wetlands' natural capabilities. The five-minute video features four items that impair wetlands, interesting facts, scenic views, and live wetland wildlife.
The entire playlist of 5 wetlands related videos is here and includes:
- Wetlands 101 - What is a Wetland?
- Wetlands 101 - 3Ps
- Wetlands 101: Wetlands & Sea Level Rise
- Wetlands 101: Wild Wetlands
- Wetlands 101 - Restoring Wetlands Part 1: Facing Challenges
There are also additional wetlands related videos including one on beach grass planting produces the the DNREC.
- Written by charlie
- Category: Other
In 2011, I permanently shut down the Wetland Wiki, as the workload of constantly editing and updating the pages became onerous, and Wikipedia had much of the same, if less detailed, information. Before shutting it down, I copied the Mediawiki (Version 1.13.1) database for posterity, and occasionally thought that some of the pages/articles I wrote should not have just disappeared, but been shared in some other fashion. 5 years later, almost to the day, I tried importing the database, and ran into many unforeseen errors, primarily due to depreciated syntax and changes in MySQL - my database hadn’t changed, but the MySQL has changed enough to make importing the database impossible without some updates.
Below are the errors I encountered while importing them into PhpMyAdmin, and how I fixed them; maybe someone else will find them useful. These few changes allowed me to import the 25MB database with approximately 200,000 lines successfully. The first error I encountered was:
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'TYPE=MyISAM' at line 8.
'TYPE=MyISAM' is depreciated, so I searched and replaced over 20 occurrences with "ENGINE=MyISAM". In a closely related error, 'TYPE=InnoDB" was also replaced with "ENGINE=InnoDB".
At this point about 20% of the database was imported successfully until the following error:
#1426 - Too big precision 14 specified for 'cl_timestamp'. Maximum is 6. which was easily corrected to timestamp(6) CREATE TABLE `categorylinks` (
`cl_from` int(8) unsigned NOT NULL default '0',
`cl_to` varchar(255) binary NOT NULL default '',
`cl_sortkey` varchar(86) binary NOT NULL default '',
`cl_timestamp` timestamp(14) NOT NULL,
UNIQUE KEY `cl_from` (`cl_from`,`cl_to`),
KEY `cl_timestamp` (`cl_to`,`cl_timestamp`),
KEY `cl_sortkey` (`cl_to`,`cl_sortkey`,`cl_from`)
The last error recieved was, #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'TYPE=HEAP MAX_ROWS=25000' at line 3. Which I updated to 'ENGINE=HEAP MAX_ROWS=25000'
Additionally, PhpMyAdmin had been timing out while importing the database after a few minutes. To lengthen the amount of time available for the import, I added the following line $cfg['ExecTimeLimit'] = 6000; to config.inc.php and restarted Apache.
After all this, the entire 25MB database was imported successfully. Now all I have to do is extract the articles, but that’s for another post!
Wetlands in the News
LEESBURG, Ga.-(Ammoland.com)-Landowners and government agencies are teaming up in southwest Georgia to conserve rare wetlands and their rarest plant species – endangered Canby’s dropwort. The U.S. Department of Agriculture recently awarded $1.19...
Instillation of two solar power gates at the Hunter Wetlands Centre has marked the finish of boundary fencing around the popular Shortland environmental site. State Member for Wallsend Ms Sonia Hornery MP was at the Wetlands on Thursday to officially open...
The Sacramento County Planning Commission voted Monday to allow developer Angelo K. Tsakopoulos to develop open space in Sacramento County’s Vineyard area that residents long believed would remain a protected wetland preserve. The commission’s 3-1 vote...
The West Bengal government has proposed lifting building and land conversion restrictions in a section of the 12,500 hectares of East Kolkata Wetlands (EKW), angering environmentalists who say the move will kill the world’s largest organic sewage...
Land reclamation projects and development along China’s coastline are endangering the country’s already-limited marine wetlands, which birds, fish, and even people depend on for sustenance and shelter, environmental group Greenpeace announced in a...